Can I create dynamic report parameters?

Hi all,

Is it possible to create a report with dynamic parameters or parameters dependant on other ones? I have the following scenario -

Parameter 1 - 'Select an Application' - List of applications that are available

Parameter 2 - 'Select a module' - This is a list of modules that needs to depend on Parameter 1. As a user selects different applications, the appropriate module list will be loaded.

Is this possible to do in SSRS?

Thanks,

Brian

Hi Brian,

Yes you can do that. Its called Cascaded parameters you need to write 2 store procedure. 1st one will be for "select an application" and 2nd one will be for "select a module" for the 2nd sp you need to pass the application id as a parameter and depending on the application Id modules will be fetched.

Once these SPs are done you need to set the report parameters make sure order of the parameters in the report parameter is correct.

Take a look at this example

http://msdn2.microsoft.com/en-us/library/aa337426.aspx

I hope this helps

Thanks

Ashwini

|||

Hello Brian,

Yes, you can do this. Take a look at 'Cascading Parameters' in Books Online.

Hope this helps.

Jarret

sql