Custom value lists are created by or supplied to Interactive Reporting. When users open the filter to choose new values, they can choose a filter from a custom list that has been supplied.
One reason to use custom lists with distributed Interactive Reporting document files is that many data items change rarely, if at all. For example, a Gender item has three consistent values (male, female, and unknown). A Product line item has many more values, but may only change every year or so. Data that changes rarely is said to have low cardinality. Under such circumstances, it makes sense for users to select from a custom values list, rather than continuously querying to show database values.
Custom lists are also useful when Setting Variable Filters. When an Interactive Reporting document file creator sets a variable filter, a custom list can be prepared and added to it. The subsequent users who sets the filter can use the custom list or read more custom values in from an external file.
To create a custom values list, use any method:
Click Show Values in Filter to retrieve the item’s values from the database, then select the values to be included in the custom list and click Transfer.
Click Custom Values and enter values individually in the edit field, then click the check mark to add each to the custom list.
Click Advanced and select Load From File to read values from a separate file. Use the Change File button to choose a file from the Select Filter File window. Click Show Values to load the values from the file to the list of values. Click Transfer to add selected values to the custom list.
Values added to the custom list can be selected to determine the filter. If the filter is converted to a variable filter, the custom list is stored in the Interactive Reporting document file and the saved values are available to users who resolve the filter.
Tip: | Imported values must be vertical-tab or paragraph delimited. |