?
Solved

Visibility in SQL Server Reporting Services

Posted on 2006-11-21
1
Medium Priority
?
2,080 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:Charles Baldo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 21

Accepted Solution

by:
Yurich earned 2000 total points
ID: 17990174
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,
Yurich
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question