Adding a Reporting Period Prompt

You can add a reporting period prompt to your report.

Procedure

If you do not already have a prompt page in your report, follow the instructions in Creating a Prompt Page.
To create your Reporting Period 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, Reporting Period.
2. Select the table cell with the text item and set the location to be horizontally right and vertically top.
3. Make the text bold using the Bold icon.
4. Drag a Value Prompt object into the second column on your prompt page.
  The Prompt Wizard opens.
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, Reporting Period.
3. Click Next.
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 LABELID query item as shown in the following example:
```
[DEFAULT_REL]|MISCELLANEOUS|REPORTING PERIODS|[LABELS]|[LABELID]
```
3. The following values are displayed in the box:
```
[DEFAULT_REL].[LABELS].[LABELID]
```
4. In the Operator box, use the equal sign (=) which is the default.
5. Clear the box for the Make this filter optional option.
6. If you have multiple queries in your report, in the Apply filter box, select the query to which the filter should be applied.
7. Click Next.
On the Populate Control screen, complete the following steps.
1. Select the Create new query option.
2. In the Name box, type a name for the query, for example, Reporting Period Prompt.
3. In the Values to display box, click the browse button and navigate to the NAME query item as shown in the following example:
```
[DEFAULT_REL]|MISCELLANEOUS|REPORTING_PERIODS|[LABELS]|[NAME]
```
  The following values are displayed in the box:
```
[DEFAULT_REL].[LABELS].[NAME]
```
4. Click Finish.