How to Increase the Length of Drop Down Menu Parameters

Is there a way to make the drop down parameters longer so more than
5-6 lines show?
Thanks
BobOn Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob|||On Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob
As far as I know, this flexibility does not exist. If a custom ASP.NET
application is an option, you might consider creating one of those and
use one of the drop-down list/etc controls and then use the report
viewer control, the Reporting Services Web Service or URL access to
integrate the actual SSRS report. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

How to identify all parameter values selected

I have the SQL query. If the user is selecting all the vendor Numbers available in the vendor number parameter drop down then, I will not include the vendor Number condition in the where portion of the sql query. For that I want to know whether the user has selected all the values available in the drop down. How to identify this?

Have a Default Value in your DropDown, for instance: SELECT ALL with the value of "" VALUE=""

which is basically null. In your where cause use an ISNULL

For instance:

@.COMPANY_ID INT = NULL

Select ID, [NAME], COMPANY_ID FROM EMPLOYEES WHERE COMPANY_ID = ISNULL(@.COMPANY_ID, COMPANY_ID)

Hope this helps.