Expand/Collapse Icon Options?
I would like to display a field that toggles Expand/Collapse data to look like a hyperlink instead of using the Expand/Collapse icon, is this possible?
April 27th, 2011 10:22am
Hi puffser,
Generally, users can click the plus to drilldown into detail data. Based on your description, do you mean that you want to use the hyperlink to click a value instead of click the plus to drilldown into detail data?
If so, there is a workaround to achieve this. We should add a parameter for the report, and add an action based on the value which is clicked on the report, using the drill-through feature to pass the value to decide the detail data is showed or hidden.
As my
last reply posted, please repeat the step1 to step4 and take the following additional steps to achieve this:
1. Add a parameter to the report(the report is named Report1), input “PassValue” in both “Name” and “Prompt” properties; and then select the “Allow null value” checkbox and the “Hidden” radio.
2. Right-click the Category field in the Table and select Text Box Properties.
3. Click “Action” and select “Go to report” option, in the drop-down list of the “Specify a report”, and then select Report1(Particular attention: the report should drill through itself).
4. In the “Use these parameters to run the report:” section, click Add. For the “Name” column, please select the parameter you created in step one. Set the “Name” and “Value” like this:
Name Value
PassValue [Category]
5. In the Row Groups pane, click Details. In the Properties window, set the “Hidden” property to the expression like this:
=IIF(Fields!Category.Value = Parameters!PassValue.Value, False, True)
6. Right-click the first row of the table and selects “Text Box Properties”, please repeat step3.
When preview the report, we can click a value to display one of the category detail data, and we can also click the table header to display the category summary data.
If you have any question, please feel free to ask.
Regards,
Bin Long
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 9:47pm