i want to create report in Oracle D2k (Reports 6i). Please help.
i have 3 tables.
1 master table: school with school_id primary key
2 detail tables: dept & employee with school_id foreign key in both
now make group in data block lay out and arrange in layout view with appropriate repeating frame.
SELECT COLUMN_NAME FROM SCHOOL,DEPT,EMPLOYEE WHERE SCHOOL.SCHOOL_ID=DEPT.SCHOOL_ID AND EMPLOYEE.SCHOOL_ID=SCHOOL.SCHOOL_ID;