Report Studio

Creating a Prompt Directly in a Report Page

You can add prompt controls directly in a report page instead of creating a prompt page.

Prompt controls that are added to report pages will not appear in the following:

saved reports
PDF reports
reports that are sent to users by email
scheduled reports

Prompt controls are by their very nature interactive. They are used to satisfy parameter values before running a report. As a result, prompt controls added to a report page only appear when you run the report in HTML format. When you run a report in HTML format, users select which values they want to see, and the report is refreshed, producing a new report.

For the non-interactive reports listed above, prompt parameter values must be collected and satisfied before the report is run. You provide the parameter values you want using the Run With Options menu option. If you do not provide all the required values, the report will fail to run.

To create a prompt directly in a Report Page:

From the Toolbox tab , drag a prompt control to the location you want it to appear.

The Prompt Wizard dialog box appears.
Provide the information necessary to create the prompt.

Note: Make the prompt optional by selecting the Make the filter optional check box. Otherwise, when you run the report for the first time, the prompt appears in a generated prompt page rather than in the report page. Alternatively, you can specify a default selection for the prompt .
In the work area, click the prompt.
In the Properties pane, set the Auto-Submit property to Yes.

If you do not set the Auto-Submit property to Yes, the report will not refresh when users select a different prompt value.

Note: An alternative to setting the prompt to auto-submit is to add a prompt button from the Toolbox tab and setting its Type property to Finish.

The prompt control is added to the report page. You can modify its properties by clicking it and making changes in the Properties pane.