Select Multiple Values for Parameters
ReportWorX64 allows users to select multiple values for list parameters. To use this feature:
-
Edit the ReportWorX64 template in Excel.
-
Open the Parameters window.
-
Select a parameter of type Select from a fixed list of values or Select from a dynamic list of values.
-
Enable Allow Multiselection.
-
If desired, enable Limit Selection to and choose a limit value.
-
Select Save and close.
-
Open Workbench.
-
Select the template object.
-
Upload your Excel file as a new version of the template.
-
Select the report object that uses your template.
-
In the Advanced Properties section, choose an option for Multi-value Parameters depending on whether you want one sheet per parameter value, or all parameter values merged into one sheet.
-
Apply the changes, if needed.
-
Use the ReportWorX64 Viewer or the ReportWorX64 button in the GraphWorX64 runtime menu to execute your report. Select multiple values for your multi-select parameters.
See Also: