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!

2nd page prints misaligned 1

Status
Not open for further replies.

BJCooperIT

Programmer
May 30, 2002
1,210
US
We have a report that prints contracts on pre-printed forms. This is the same report referenced in thread442-1099950. Normally a contract is only one page, but once in a while it does span multiple pages. Since they assigned a different printer definition to stop the "blank page" problem, there is now a new issue. The 2nd page is misaligned.

I made the main frame 11 inches high, vertically fixed, but the 2nd page starts printing at 10.5 inches (meaning the 2nd page begins printing at the bottom of the first page). The obvious solution is to use a different printer definition, but that is outside my control. Can you think of another solution?

[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
 
Thanks for responding. Changing the frame height has no effect.

[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
 
I will give it a try.

[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
 
Followup: This report was skipping a page after each contract on a line printer. My client had assigned it to a printer definition without a formfeed. This meant that the multi-page contracts had pages 2, 3, 4... misaligned because they never skipped to the top of the page. My challenge was to make multi-page contracts work with this printer definition.

Solution:
[ol][li]Added a query to data model to find the number of rows for the contract in order to calculate how many pages it would fill.[/li]
[li]Added a repeating frame in the bottom right hand corner based on the new query[/li]
[li]In the repeating frame I added a text item of "-"[/li]
[li]Added a trigger to the repeating frame to print only if a multi-page contract and the current page is not the last page[/li]
[/ol]
Hope this helps someone else.

[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