The Parameters tab displays all the parameters such as project defaults and report parameters that are assigned to the selected menu item.
-
In the Parameters tab, click Add Row to add parameters.
-
Type a sequence number.
-
Select a parameter from the Parameters list.
-
Select a default value from the Default Values list.
-
Select Yes in Change Allowed list to enable change of default value and then click Save.
-
Type a command in Command for reduced list of values.
You can reference other parameters of this menu by using # sign for the application to identify references to other parameters.
Example 1: If you have selected a commodity ID, P_COM_ID parameter, and for the parameter P_POST_ID, you want to restrict the data based on the chosen commodity ID.
Example 2: Displaying referenced parameters regardless of the restrictions starting with WHERE or AND:
-
where post.commodity_id = #P_COM_ID# order by 1;
-
- and decode( #P_DISCIP# , '%', to_char(cr.dp_id), cr.dp_id) like #P_DISCIP#
-
-
Type a command in Command for lexical report parameter.
This cell specifies the select-statement for lexical-parameters.