February 22, 2012 at 4:26 pm
Hello all
I am new to SSRS as is probably obvious from my question.
Im wanting to display Tables in a DB as a report param list and the selection from this list displays the corresponding Columns available in another report param list, with the possibility of a filter also. These selections define the report content. Multiple or all column selection is obviously necessary. Ive been able to create querys and stored procs for these actions in SSMS but thats all.
Im using SSRS 2008.
Any help appreciated.
February 23, 2012 at 7:04 am
What you are talking about is cascading parameters. Generally the way I do this is to start with the dataset query that will generate the actual report data using all the required parameters. If you are using stored procedures, just write the stored procedure and then use that as your dataset.
Next add your query, SP, for the first of the parameters, and then go to the parameter list, and into properties for the appropriate parameter and go to the Available Values tab and make it draw data from your query.
Then go to the next parameter with the next query/SP and do the same thing. It is easiest of all the parameters in the various queries are named exactly the same. Finally make sure that the first parameter you need is at the top of the parameter list, and the second parameter is second and so on by moving the parameters up or down.
February 23, 2012 at 3:13 pm
Thanks Daniel for your reply. Your information has been very helpful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply