• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2090
  • Last Modified:

Visibility in SQL Server Reporting Services

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.

Charles Baldo
Charles Baldo
1 Solution
Setting visibility for exporting reports is not very well supported in MS Reporting Services, but I just have run a little test and if you use a visible property rather than toggle item, then exporting exports only visible items.

First of all, delete/remove everything what you've done for your toggle item property.

Now. Say, you have a parameter of type String named prmShowDetails with two values 1 and 0 and labels Yes and No. The prompt is something like: "Show details". And if the value is No (0) you don't want to show your table. (can be different type of parameter - it doesn't matter).

Select your table (the one you want to hide), right click it and go to parameters, select visibility, select expression, and type in this code in there:

=Parameters!prmShowDetails.Value = 0

Now, when you select No, your table should not be visible and if you export your report into excell after that, the table should not be visible in the excell file either.

It's all tested, so it should work for you.
Good luck,
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now