<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
I have created a report using MS SQL Server Reporting Services. I pass a parameter to the report to show the summary/detail data. <br />
Parameter : reporttype(Values 0/1). If 0 is passed it has to show detail data otherwise summary data.<br />
<br />
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. <br />
<br />
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.<br />
<br />
I am displaying the data in a table.<br />
<br />
Any help is appreciated.<br />
<br />
Thanks,<br />
Chuck.
</div>
</div>


Hello All,

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.

Thanks,
Chuck.

Visibility in SQL Server Reporting Services

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.