Parameterizing the Crystal Reports Queries Setting
The following example describes, in basic terms, the solution for a typical parameterization of the pre-calculation from Crystal Reports queries. You can find additional information about the individual steps underDefining Crystal Reports Queries Settings.
A user wants to execute a Crystal Report for various cost centers and various fiscal years.
The BW Reporting Agent allows you to vary within all posted cost centers and required fiscal years in a single background run. In this way, all associated data records are pre-calculated.
In the query definition of the "useful query", the variables have been set for the following characteristics:
We recommend you choose the Changeable with Query option for the variable for the Cost Center characteristic (refer to "Procedure", step 1).
In the BEx Query Designer, define a control query.
A very simple query particularly lends itself to such an auxiliary query: The control query must have the Cost Center characteristic, according to which the system is to filter in our example, in the rows drilldown. Every row in the table delivered by a control query functions as a dynamic filter for the pre-calculation of the "useful query" for Crystal Reports.
In the Parameters tab page, in the Variants area, create the required variants for the individual characteristic values.
When executing the background job, the system varies in all variants created for the values of characteristic Fiscal Year, and, for each variant, in all values of the characteristic Cost Center made available by the control query.