Report Parameters with Predefined Dynamic Values

<< Click to Display Table of Contents >>

RayVentory Data Hub > 12.5 u5 > Dashboards and Reports Customization Guide > Designing Reports > Use Report Parameters > Create a Report Parameter 

Report Parameters with Predefined Dynamic Values

You can create a report parameter that uses a list of values from a data source.

 

eurd-web-dynamic-parameter-values

 

When you open a report's Print Preview, you can select a value from this list in the Parameters panel.

 

report-parameters-dynamic-values-preview

 

Create a List of Predefined Values in the Report Designer

Follow the steps below to create a parameter with a list of dynamic values in the Report Designer:

 

1.Create a report parameter as described in this topic: Create a Report Parameter.

2.Set the parameter's Value Source option to Dynamic List. Additional fields appear in the Add New Parameter dialog and allow you to specify a data source for parameter values.
 
parameter-specify-dynamic-values
 

3.Specify the Data Source, Data Adapter (for a DataSet only), and Data Member options. Value Member defines a data field that supplies values to the parameter. Display Member defines a data field that stores value descriptions displayed in the Parameters panel.
 
report-parameters-dynamic-values16951

 

papercliper

Note:

The data member's value type should match the specified parameter Type.

 

Use the Filter String property to filter parameter values or implement cascading parameters. Specify the Sort Order and Sort Member properties to sort parameter values in the Parameters panel's editor.