Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Filtering report data using passed URL parameters

Author  Topic 

plightstone
Starting Member

2 Posts

Posted - 2010-12-05 : 13:27:12
I am passing a parameter in a URL to an ssrs report. How do I use that in the report? In the dataset? As a filter in a table or chart? How do I reference it?

For instance, let's say the following is my URL to a report:
http://<Server Name>/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&Year=2002

Now, I've passed a parameter called Year with a value of 2002. So how do I use that within the report. Can I use it in the dataset some way to make sure a date in the table is after this? Or, do I use it in a filter of a table or chart?
   

- Advertisement -