April 17, 2009 at 10:29 am
Hi all,
I have created an SSRS report with parameters. When viewing/previewing the report the parameters are pre-filling correctly but after selecting the appropriate parameter and click view report I get the basic report without parameter filtering. How does the parameter get connected to the view? I have a seperate dataset for the parameter list. I have also deleted and recreated the parameter to see if that connects the two. What am I missing?
April 18, 2009 at 5:15 am
You need to include the reference to the parameter you have created in your dataset if you are using embedded T-SQL. Take a look at one of the Tutorials in the BOL to guide you through this process.
Tutorial: Adding Parameters to a Basic Tabular Report
If you are use stored procedures here is a different example.
Setting Report Parameters with Stored Procedures
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply