Home » Developer & Programmer » Reports & Discoverer » In oracle Reports how to print on a new page
In oracle Reports how to print on a new page [message #366808] Thu, 07 September 2000 06:53 Go to next message
Anju
Messages: 33
Registered: September 2000
Member
Hello,

The scenario is like this. There are two tables dept and emp, grouped by deptno. When the deptno chages the report should print on next page.

dept no 1 and its employees page 1.
dept no 2 and its employees page 2.

Any ideas will be appreciated.

Thanks in advance.

Anju
Re: In oracle Reports how to print on a new page [message #366810 is a reply to message #366808] Tue, 12 September 2000 04:08 Go to previous message
LB
Messages: 13
Registered: September 2000
Junior Member
Hi Anju,

Set the 'Maximum records per page' property for your dept repeating frame to 1. This will ensure that only one department number prints on a page. If it needs to spill over onto a second page it will still produce a page break before it starts the next dept. Hope this helps.
Previous Topic: Reports-Problem in Cheque Printing-Top Urgent
Next Topic: Right Margin in Report 6.0 Increases Automaticaly
Goto Forum:
  


Current Time: Fri Apr 19 08:50:36 CDT 2024