Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

form letter with 4 pages 1

Status
Not open for further replies.

latha9

Programmer
Dec 20, 2005
12
US
I am trying to create a 4 page form letter. The first page contains fields from a sql select and some static text and the second page is static text with date in the middle of the text. 3rd page is same as the first page with with small changes. CAn i use the same query for the first page and 3rd page.and 4th page is same as the 2nd page.even i dont know how to create 4 pages.i am new to oracle reports.can anyone please help me how to do it.if my query returns 2 rows all the pages should print 2 times.
please HELP!!!!

Thank you
 
Nothing prevents you from printing a field multiple times, so you probably only need your 1st query. When in design mode on the canvas there are lines that represent the bottom/top of pages that will help you space fields on the proper page. Once you have created your four page layout across these lines you may need some anchors to keep things in place, but it certainly sounds doable.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top