Solved

Visibility in SQL Server Reporting Services

Posted on 2006-11-21
1
2,070 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:charlesbaldo
1 Comment
 
LVL 21

Accepted Solution

by:
Yurich earned 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now