Previous Next

How to insert a parameter marker in the SQL query

This procedure assumes that you already created a data set.

1  
2  
WHERE quantityinstock < ?
WHERE quantityinstock <= ? AND productvendor = ?
WHERE quantityinstock <= ? OR productline LIKE ?
Figure 11-2 shows an example of a query with two parameter markers.

Figure 11-2 Query with two parameter markers

Figure 11-2  Query with two parameter markers

At this point, you are ready to define a data set parameter for each ? parameter marker. The next section describes this task.

How to define a data set parameter

This procedure assumes that you already inserted a parameter marker in the SQL query.

1  
2  
3  
4  
In Edit Parameter, specify the following information:
1  
2  
3  
4  
Figure 11-3 shows an example of a data set parameter definition where the data set parameter, DSP_quantityinstock, is linked to a report parameter, RP_quantityinstock.

Figure 11-3 Data set parameter definition

Figure 11-3  Data set parameter definition
5  
5  
Repeat steps 3 and 4 to define additional data set parameters for any other parameter markers in the SQL query.
6  
7  
1  
2  
Enter Parameters displays all the report parameters you created. Figure 11-4 shows example report parameters, RP_quantityinstock and RP_productvendor. The parameter names appear because values were not supplied for the Prompt text property.

Figure 11-4 Enter Parameters

Figure 11-4  Enter Parameters
3  

If you completed all the tasks that were described earlier in this section, the WHERE clause of the query incorporates the specified values, and the report displays the rows that match the WHERE clause.


(c) Copyright Actuate Corporation 2013