Create List of Values
Create a List of Values for Reports Wand in an Excel cell.
There are two types of in-cell list of values that can be created.
Type | Description |
---|---|
Oracle Value Set | A standard Table Validated or Independent Oracle Value Set. Any table validated value sets that include :$FLEX$ or similar form references will not be supported. |
Report Definition Custom List of Values (LOV) | A custom SQL based value set. How to create a custom List of Values. |
Select the type of List of Values you would like to create.
Select the relevant Value Set and click on the Create button to complete the process.
Double Click on the cell in Excel to open the List of Values. The List of Values is filterable.
By default, the cell containing the List of Values will have a formatting of text. This can be changed by the user should it be necessary. Select the cell > right click > Format Cells.