Solved

Visibility in SQL Server Reporting Services

Posted on 2006-11-21
1
2,069 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
How to increase the row limit in Jasper Server.
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

910 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

21 Experts available now in Live!

Get 1:1 Help Now