Displaying/Mapping Parameters in Excel Sheet

 

Parameters can now be displayed in the sheet. Mapping parameters is similar to the way data sources are mapped. Select the cell or cell range you'd like to map, then go to the ReportWorX64 menu and choose Add > Parameter Source from the Edit Data Source section.

 

An existing populated cell can be turned into a parameter. For example, if cell A1 contains an asset name and you would like to make that name into a parameter, select cell A1, go to the ReportWorX64 menu, and choose Turn Cell Into Parameter in the Edit Parameters section. The cell will appear as a mapped cell, mapped to a new parameter. Select ReportWorX64 > Parameters to edit properties of this new parameter, such as its data type and display name.

 

Parameters can be added or edited using the Parameters button in the ReportWorX64 menu.

 

When using the Download Data button to populate the report, if there are any parameters that require user input, a dialog will appear to let the user choose those values. This allows ReportWorX64 Express customers to take advantage of parameters, and full ReportWorX64 customers to test parameter values before uploading their workbook as a template.

 

See Also:

Excel Add-In

About Reports in the Workbench

Multiple Value Selection for Parameters