August 7, 2008 at 2:11 pm
Hey all,
I'm having an issue to where a report subscription won't display the data that is toggled by another item. I've tried web archive, excel and .pdf ... all return the same results. It simply shows my toggle header, without the data that is hidden by expanding it, nor the ability to toggle it.
Is this by design? Is there a way around it?
Thanks
August 7, 2008 at 2:16 pm
This is by design. When you save as PDF, it shows what's on the screen so when you directly go to PDF, etc. you need to have everything expanded by default. You might want to add a hidden parameter to the report for toggle status and set it to expanded on your subscriptions and default it to collapsed in the report definition.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 7, 2008 at 2:20 pm
Damn, figured as much ...
How do you accomplish what you're saying? How can you have a parameter that toggles result sets?
Thanks
August 7, 2008 at 2:47 pm
It's actually quite simple. Go to report parameters and add a parameter called Toggled that will be a boolean and Hidden. Set the default to TRUE (the thing you are actually setting is the Hidden property of the item you are collapsing). In the Hidden Property of the item you are toggling set the value to =Parameters!Toggled.Value. Then in your subscription you set the Parameter to False.
Attached is a report that has the parameter and the detail row's hidden property set. The report using AdventureWorks so you should be able to run it in BIDS if you have AdventureWorks installed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 7, 2008 at 3:05 pm
Perfect! Thanks Jack, much appreciated.
August 7, 2008 at 7:35 pm
No problem. Glad I could help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply