Hide or Show Sections in RDLX and RDLX Dashboard Reports

The RDLX and RDLX Dashboard Reports are reports with multiple sections. You can control the visibility of the initial state of a section using Hidden property.

Hidden property

This property controls the visibility of the report sections based on the expression that you specify or the value you set, that is, True or False. If you want to hide the report page, set the property to True. In case you want to conditionally hide the report page, enter a suitable expression.

Conditionally hide/show a report section

Let us assume that the report has few sections and we want to hide one of the sections. The procedure to hide a section in RDLX and RDLX Dashboard Reports based on user input is described below.

1. Create a report parameter. In the Report - Parameters dialog, set the following:

   • in General tab:

   • • Name: ShowHideParam
     • Data type: Boolean
     • Text for prompting users for a value: Select whether to hide the section

   • in Default Values tab:

     • select Non-queried option
     • Value: false
       

2. Select the ReportSection/Section tab of the report that you want to hide.

3. Go to the Hidden property of the section and enter the expression as shown:

   =IIF(Parameters!ShowHideParam.Value=True, True, False)
   

4. Preview the report.

5. From the Parameters panel, select 'True' to hide the section.
   Similarly, for the hidden section to show, select 'False'.