Answer Posted / swarna.alizerla

we can create lexical parameter & bind parameter in the
report in the data model query.
The bind parameter is used as well and lexical parameter
used for ex:

select &deptno,ename,deptno from emp where empno=:empno

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2227