Using substitution variable in Report Builder
Posted on 2002-03-21
How can one use the substitution variable in Report Builder at runtime so that the end user has the option of using the where clause with any field/column of his choice. In SQL*Plus, the follwoing query works fine:
where &condition1 and &condition2
order by &order_column;
but when I uses the same syntax in the query builder of report builder, syntax errors are given. Any ideas? How can we use the same query in Report Builder? I have used query in Report Builder having one or more columns defined as bind variable so that their values are given at runtime having the following syntax:
where empno = :P_1;
I want that the end user should have the option of using any column/field with the where clause at runtime so that he is not restricted to give values of only those columns which have been previously defined in the query.
Thanks in advance.