Previous Topic  Next Topic

Controlling Multiple Parameters

When multiple parameters are used in a report, but you only want to show some of them when running it, you can group them and then select the parameter you want for the report. The parameter values not entered will use their default value. See the example below:

1. Open the catalog file SampleReports.cat in <install_root>\Demo\Reports\SampleReports.
2. In the Catalog Manager, expand Data Source 1, then right-click the Parameters node and select New Parameter.
3. In the New Parameter dialog, enter GroupParam in the Name field, select Parameters from the Value Type drop-down list, then add three parameters as the default values of GroupParam as shown in the following image:

   

4. Open an existing page report. Insert the parameters P_Category, P_Month, P_Country, and GroupParam into a report tab of the report.
5. View the report, and the Enter Parameter Values dialog appears. You can select the parameter you want from the GroupParam drop-down list.

   

   Select @P_Category, the P_Category parameter is displayed in the dialog and you can select or type in a value for the parameter. If you select @P_Month,@P_Country, then both the parameters P_Month and P_Country will be displayed for you to specify values with which to run the report.

Previous Topic  Next Topic