OraFAQ Forum: Reports & Discoverer » Letter report printing in oracle reports

Home » Developer & Programmer » Reports & Discoverer » Letter report printing in oracle reports (Oracle 9i,Forms 6i,Oracle Report Builder 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Letter report printing in oracle reports [message #648590]

Thu, 25 February 2016 21:39

sikandar4u
Messages: 12
Registered: February 2016
Location: KOLKATA

Junior Member

I have a requirement of printing a report in letter format. Rdf is containing two repeating frames.Outer Repeating frame contain layout of letter where as inner repeating frame contain rows of data. Requirement is if rows of data in inner repeating frame is increased and it goes beyond first page it should print "continuation " in bottom of current page.

Can u please suggest what can be done?

Report message to a moderator

Re: Letter report printing in oracle reports [message #648648 is a reply to message #648590]

Sun, 28 February 2016 05:30

Littlefoot
Messages: 21760
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's the SRW built-in package which offers the GET_PAGE_NUM function; it returns the current page number. Unfortunately, there's no function which returns TOTAL number of pages (so that you could compare current page number with it and display a note at the bottom of the page). Therefore, you'll have to write some code yourself.

People usually use a package in order to do that. Have a look at Total Pages discussion. It refers the My Oracle Support document ID 130432.1 and provides code you should study and adjust according to your needs.

Report message to a moderator

Previous Topic:	Printing custom size (15 * 12 inch) paper in Dot matrix printer
Next Topic:	Help Needed in Report Formatting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 30 09:43:08 CDT 2023