Select Multiple Values for Parameters

ReportWorX64 allows users to select multiple values for list parameters. To use this feature:

1. Edit the ReportWorX64 template in Excel.

2. Open the Parameters window.

3. Select a parameter of type Select from a fixed list of values or Select from a dynamic list of values.

4. Enable Allow Multiselection.

5. If desired, enable Limit Selection to and choose a limit value.

6. Select Save and close.

7. Open Workbench.

8. Select the template object.

9. Upload your Excel file as a new version of the template.

10. Select the report object that uses your template.

11. 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.

12. Apply the changes, if needed.

13. 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:

Displaying/Mapping Parameters in Excel Sheet