Selection Page with a Prompt

The prompt in the selection page can be filtered automatically based on other values entered in the selection page. For exemple, a selection screen with the General Ledger setting and the GL Account can use the value in the General Ledger parameter to filter the list of GL Account.

Example

Here, we will define a selection page with two fields: Product Stats Group 1 and Product Stats Group 2:

  1. In the Data Models and View tab, right-click a data model and select Edit Selection Page.

  2. In the upper left hand corner, click Add a New Selection Page.

  3. Enter a name for your selection page and click Product Stats Group 1 and Product Stats Group 2 in the Fields list on the right to add them.

  4. In the data model, add a column Product Stats Group 2 that will contain the value of Product Stats Group 1 and make sure to configure the correct global parameter for this column.

  5. Begin using the selection page.

  6. Filter by the selected product.