Answer Posted / dinesh mohan upadhyay

trere are five types report trigger
1 before parameter form
2 after parameter form
3 before report
4 between pages
5 after report

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

2221