Creating a prompt page for the complex report

Create a prompt page containing prompts for the report parameters.

  1. Click Report > Prompt Page.
  2. Click Page design.
  3. Click inside the first row of the table and click ... > Insert > Rows below.
  4. Specify 2 and click OK.
  5. Click Toolbox and drag the Text Item into the first row of the table.
  6. In the Text window, specify Store: and click OK.
  7. Expand Prompting and then drag the Select & search prompt object into the second row of the table.
  8. In the Prompt Wizard - Select & Search Prompt window, select the Use existing parameter option and then select the Store parameter from the drop-down box.
  9. Click Next.
  10. Select the Create new query check box and then specify this information:
    Name
    Specify SelectStore.
    Values to use

    Displays the value for the Store parameter value that was defined earlier. Leave the default value, which is [Scheduling].[Store].[SKDGRP_ID].

    Values to display
    Click …, select Ad-Hoc Query Layer > Scheduling > Store > Store Name, and click OK.
  11. Click Finish.
  12. Add a Text Item object to the third row of the table and specify Start Date:.
  13. Add a Date Prompt object to the fourth row of the table and select the Use existing parameter option.
  14. Select the Start Date parameter from the drop-down box and click Finish.
  15. Add a Text Item object to the fifth row of the table and specify End Date.
  16. Add a Date Prompt object to the fourth row of the table and select the Use existing parameter option.
  17. Select the End Date parameter from the drop-down box and click Finish.