Selection Screen for Parameters?

Hot Topic

Consuming Web Services In Sql CLR
Error on bcp
nsInstance.Initialize errors out
Cannot generate SSI Context
Problems with Oracle character setting
Creating a Table Of Contents
TOP 100 ordering of Data Question
Creation of credentials and certificates to protect a DB
Can't SqlCommand - Help.
efficient JOIN query

SQL Server

Question about dataasource and the .rdl file and the .rdl.data
How to run an exe in the SSIS scripting task
MSRS + Fit to Page
RowNumber in Report builder?
"Open Table" NOT WORKING. Can someone HELP!
Client Printing Hangs
Can a Snapshot report be created programmatically?
Report Server (MSSQLSERVER) cannot connect to the report server database.
my money cast no longer works in sql 2005
Report Builder fatal error

Selection Screen for Parameters?

Hi...

I want my report to display records that match parameter X, but the users cannot just type in or pick the parameter from a dropdown, because there are thousands of possibilities. I want to give them a way of searching for or narrowing down a list until they find the desired value.

Does anybody have an idea of the best way to approach this using Reporting Services Cascading parameters Subreports Separate linked report Anything else

Thanks!!!



Answer this question

Selection Screen for Parameters?

  • Casey0001

    First you need to understand the distinction between 'Report Parameters' and paramaters that your datasets require. They are two different things. You may have as many (or few) report parameters as you like and they don't have to map to dataset parameters.

    So, you would create a bunch of report parameters, then setup dependences between them. This would allow users to narrow the parameters as the pick them.

    Cheers

    Paul



  • Selection Screen for Parameters?
Answer this question