A parameter associated with a database column that passes an expression to dynamically extend the query’s WHERE clause. An ad hoc parameter uses Query by Example (QBE) syntax to restrict the number of rows returned from the data source to the report. The tools that support ad hoc parameters are Information Console and Management Console. For example, in Figure G-2, the value in the first field translates to the following SQL (Structured Query Language) expression:
|
Figure G-2
|
