Last post Jul 26, 2011 09:12 PM by You-Hu Fu
Jul 20, 2011 03:12 PM|sherifffruitfly2|LINK
I've made an SSRS report, and have it embedded into an aspnet page. What I want is a pair of radio buttons on the page, which filter out (or not) certain records.
The only way I know to do it at the moment is to create an entire new report, whose underlying query contains the filter in a sql WHERE clause, and when the user clicks the radio button, just switch the report shown.
Seems like there should be a way to achieve the same effect without an entirely new report, though. What's a better way to do this?
Thanks for any ideas,
Jul 26, 2011 09:12 PM|You-Hu Fu|LINK
You can also jump to your original report rather than the new report and give the parameter to the main report's SQL Where clause. Besides this, you can also add the filter to the dataset or data region on the main report.