Adding a Date Prompt

You can add a date prompt to your report.

Procedure

  1. If you do not already have a prompt page in your report, follow the instructions in Creating a Prompt Page.
  2. To create your Date prompt, complete the following steps.
    1. Drag a Text Item into the first column of the table. Enter the text for the prompt in the text item.
    2. Select the table cell and set the location to be horizontally right and vertically top.
    3. Make the text bold using the Bold icon.
    4. Drag a Date Prompt object into the second column of your prompt page.
      The Prompt Wizard opens
  3. On the Choose Parameter screen of the Prompt Wizard, complete the following steps.
    1. Select the option Create a new parameter.
    2. In the box, type a name for the parameter, for example, Start Date:.
    3. Click Next.
  4. On the Create Filter screen, complete the following steps.
    1. Select the option Create a parameterized filter.
    2. In the Model item box, click the browse button and navigate to the following query item: 
      
DEFAULT_REL|GRC_OBJECTS|[SOXCONTROL]|[CN_CREATION_DATE]
    3. In the Operator box, use the equal sign (=) (default).
    4. Clear the box for the Make this filter optional option.
    5. If you have multiple queries in your report, in the Apply filter box, select the query to which the filter should be applied.
    6. Click Next.
  5. Select the prompt you just created and under the General category in the Properties pane, change the Select UI value to Edit Box.
  6. Run the report.