This page will guide you through the steps to make the matrix more user-friendly and reduce the number of clicks to expand the whole matrix.

Visibility options

...

• Here, I have selected the visibility Visibility options according to my requirement.

• In Hidden, choose one of the following options to set the visibility of this report item the first time you run a report:

  • Select False to display the report item.

  • Select True to hide the report item.

  • Select <Expression> to open the Expression dialog box to create an expression that is evaluated at run time to determine the visibility.

• InitialToggleState gives you the ability to keep the toggle state on or off when you run the report.

• In ToggleItem, from the drop-down box, select the name of a text box to which to add the toggle image.

...

• Click on Visibility and select Show option for When the report is initially run.

• Check Display can be toggled by this report item and select the appropriate column and click OK.

• Click Run and see the results