Articles in this section
Category / Section

How to Dynamically Change the Initial Toggle State Based on User Input

Published:
Updated:

In Bold Reports, users can modify the initial toggle state of the tablix or matrix report item values based on their preferences in the preview. The ability to dynamically change the initial toggle state in Bold Reports enhances user experience and facilitates improved data presentation. By allowing users to control the visibility of expanded details in tablix or matrix reports based on their preferences, this feature offers flexibility and customization. Users can choose to view only the essential information or expand to see more detailed data, tailoring the report to their specific needs. This functionality enhances the usability of reports, making them more intuitive and user-friendly.

To achieve this requirement, follow the steps below:

  1. Create a new Boolean parameter to toggle visibility.
    image.png
  2. Add a tablix report item and map the fields as per your requirement. Then set the drill-down for any of the groups or detail rows in the report.
  3. Set the visibility of the toggle item based on the user’s input using the expression shown below:
=NOT(Parameters!<Your_BooleanParameter_Name>.Value)

In the above expression, the “NOT” operator will return the opposite value. If the value of the created Boolean parameter is true, it will be changed to false and vice versa.

In our example, the condition for the “SubCat” group toggle visibility is set. Please refer to the image below for your reference.

image.png

image.png

=NOT(Parameters!ShowDetails.Value)
  1. Once the parameter and conditional expressions are set, save your changes and preview the report to see the dynamic toggle state in action. Users can enable or disable the display of expanded details according to their preferences.

    Output :
    When the user disables the “Show Details” parameter and then views the report, the report will preview with collapsed values.

    image.png

    When the user enables the “Show Details” parameter and then views the report, the report will preview with expanded values.
    image.png

For your reference, the sample report is also attached here.

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied