Background
Parameters are a key factor to making RDLX reports more interactive. With certain use-cases, it is important to select more than one option from the drop-down list within a parameter. This can be used to show many different data fields in a report without using more than one parameter.
Prerequisites
I will be using the WebDesigner_MVC sample from our GitHub, as well as the “Categories” dataset that is included in that project.
Steps to Complete:
-
Run the sample to see the Web Designer in your browser. In the Web Designer, start by adding a table control to the report. Drag the CategoryId, CategoryName, and Description fields (from the Categories dataset) into the detail row of the table. Format the table by expanding each column to fit the contents, and click preview in the top-left corner to see the results.
-
Now let’s add a parameter to the report. In the same area where we grabbed the data fields, there should be a section that says “Parameters”. There, we can add a parameter and change it to have the following settings:
-
Afterwards, select the table and go to the “Properties” tab. From here, scroll down to the Filters section and add a filter. Input the following filter using the expression editor:
-
The expression editor is used here because a multi-value parameter uses an array to sort through each selection. In the expression, we combine each option from the drop-down list into an array, and then display the data fields that the user has selected to the report.
-
Finally, we can preview the report and see that our multi-value parameter is working correctly.
If you’d like to see more information on multi-value parameters, check out this documentation.
Christian Wirt