Answer Posted / Ramesh Babu

In Oracle Report Developer 10g, you can add buttons and checkboxes to your reports using the Report Builder's palette. Here's a brief guide:
1. Drag and drop the desired control (Button or Checkbox) from the palette onto your report design area.
2. Configure the properties of the control (such as label, action, etc.) in the Properties window.

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