Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Reporting Services incorrect icon on show/hide group

I have created a parameter on a report that allows the user to open all the group details or hide group details when the report is run.

This works, but when you run the report and select to expand the groups, the little icon use use to show/hide on the report is a + symbol instead of a - one.

While the actual report is right, i can see it confusing the users somewhat as it looks like there is something hidden, when in fact its all there -

alt text http://www.beakersoft.co.uk/img/report_icons.gif

Any one seen this or know how to fix it?

like image 455
beakersoft Avatar asked Jul 15 '09 09:07

beakersoft


People also ask

What is toggle item in SSRS?

The visibility settings within SSRS are one way of making a report interactive. It allows the report developer to set which data is shown and which data is hidden when the report is initially run. The toggle settings then allow the end user to click the +/- sign to drill down to further detail within the same report.

Does SSRS work in Edge?

Yes. The default authentication settings work with Edge.


2 Answers

This problem (wrong display of plus-minus tiny toggle icon) occurs when you want to initially set the Visibility as Show, in the Group Properties (bottom left pane, Row Groups, right click). The solution is to:

  1. Click the text box where the toggle icon should appear
  2. At the property pane, near the bottom, under the Visibility, set InitialToggleState to True
like image 169
Irawan Soetomo Avatar answered Oct 06 '22 00:10

Irawan Soetomo


You can set the initial appearance of the toggle icon for the textbox properties (The textbox that controls the visibility of a row/group). You can find this setting under the Visibility tab of the textbox properties dialog box. Use an expression to determine the initial appearance of the icon for different toggle items.

See this short article for more info:

like image 41
lukehayler Avatar answered Oct 06 '22 00:10

lukehayler