April 20, 2009 at 7:34 am
I created a report that allows the user to Expand or Collapse all detail rows with one single option using the following code below. It works GREAT in Visual Studio, BUT it will NOT work properly in Report Manager. :crying: WHY? Is there a fix for this or another way to make this work?
Parameter Name: ShowNoteDetails
Data Type: Boolean
Non-queried values as follows:
label values
----- ------
Yes True
No False
Default Values:
Non-Queried : False
Visibility property of the row :
=iif(Parameters!ShowNoteDetails.Label="No",True,False)
InitialToggleItem property :
=iif(Parameters!ShowNoteDetails.Value ="True",True,False)
April 20, 2009 at 7:43 am
What is the behavior you are seeing in Report Manager?
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
April 20, 2009 at 8:01 am
The expand and collapse is not working properly in Report Manager as it is in Visual Studio. When selecting expand all, nothing happens, when selecting collapse all, nothing happens, the toggle signs are incorrect. BUT, in Visual Studio, it works just fine, all the toggles work properly, expand/collapse works properly...
THANK YOU SOO MUCH FOR REPLYING ! Do you know what the issue may be or how to make this work correctly?
April 20, 2009 at 8:28 am
What version of SSRS are you using? I don't have an InitialToggleItem Property on a row in a table using 2005.
I am attaching a report that uses a Parameter to expand/collapse all items in a report. One thing to remember with this is that you need to re-submit the report and it will go back to the DB again when you change the parameter. The report uses the adventureworks db.
I am seeing the behavior I expect both in BIDS and when the report is deployed.
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
April 20, 2009 at 8:58 am
Thank you, I'll take a look at the attachment. I'm using SSRS 2005.
I'm confused as to why it will work correctly in Visual Studio, but not in Report Manager after deployed... ??
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply