Solved

Visibility in SQL Server Reporting Services

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 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

17 Experts available now in Live!

Get 1:1 Help Now