Answer Posted / Rajat Madan

In Oracle Forms Reports, a complex report can be prepared by using various features such as Subreports, Crosstabs, and Grouping. To prepare a complex report, follow these steps: 1. Design the report structure using the Report Wizard or by manually creating it in the Form Editor. 2. Add necessary sections, subreports, and groupings as needed. 3. Set up the report properties such as column widths, page breaks, and header/footer information. 4. Define queries for data retrieval and bind them to the appropriate sections. 5. Run the report using the Form Builder or by executing it from a menu item.

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