Visibility in SQL Server Reporting Services
Posted on 2006-11-21
I have created a report using MS SQL Server Reporting Services. I pass a parameter to the report to show the summary/detail data.
Parameter : reporttype(Values 0/1). If 0 is passed it has to show detail data otherwise summary data.
I am using a toggle item to display the details. And if I do not want to display the details I will hide the textbox on which I am toggling.
This works fine when I run the report. But when I export it to excel, even when I run the report for just summary data all data including details are exported to excel and I want only the summary data to be exported.
I am displaying the data in a table.
Any help is appreciated.