OraFAQ Forum: Reports & Discoverer » Printing Report on papers

Home » Developer & Programmer » Reports & Discoverer » Printing Report on papers (oracle 10g , windows xp)

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

Printing Report on papers [message #338432]

Tue, 05 August 2008 01:26

esraa90
Messages: 63
Registered: May 2008
Location: EGYPT

Member

Dear All,
My report works well on desktop records for each employee on a page then next page for the next employee.
But when I print the report some employee records comes on two papers.
I think page on paper differ from page on desktp .
I am using A4 .
What should I do?

Kindly, help.

Report message to a moderator

Re: Printing Report on papers [message #338459 is a reply to message #338432]

Tue, 05 August 2008 03:15

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't report to moderator to get attention, read forum guide you will see you just get the opposite.

Regards
Michel

Report message to a moderator

Re: Printing Report on papers [message #338484 is a reply to message #338432]

Tue, 05 August 2008 04:03

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

Senior Member
Account Moderator

The reason might be difference between report's layout size and paper size.

Go to Object Navigator, expand Paper Layout node and choose Main Section. Open its Property Inspector window and adjust Width and Height so that they would reflect paper size (A4). It is possible that you'll have to calculate these values if report sizes are in inches, while A4 is in centi/milimeters. 1 inch = 2.54 cm.

Report message to a moderator

Re: Printing Report on papers [message #338553 is a reply to message #338484]

Tue, 05 August 2008 05:59

esraa90
Messages: 63
Registered: May 2008
Location: EGYPT

Member

I already did that, but not OK.

My report is HTMLCSS format, I think Enternet Explorer read it as one page.

If I should change format tell me the better solution.

All what I need is to print records for every employee on one paper.

Report message to a moderator

Re: Printing Report on papers [message #338612 is a reply to message #338553]

Tue, 05 August 2008 07:57

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

Senior Member
Account Moderator

Hm, now I'm confused a little bit. Are you talking about the "Page Protect" frame property which should be set to "Yes"? Or should you redesign your report so that all fields fit the same page?

Report message to a moderator

Re: Printing Report on papers [message #338621 is a reply to message #338612]

Tue, 05 August 2008 08:33

esraa90
Messages: 63
Registered: May 2008
Location: EGYPT

Member

I have page protect 'Yes' for employee frame.

There is no problem when running report on desktop using report builder, each employee comes in one page.
I've also page break after for employee frame.

The problem happens when calling reprot from explorer and print on paper.
I'll attach 'print preview'.
/forum/fa/4729/0/

Kindly, it is clear in the attachment .
Why page 2 comes in same paper with page 1?

Attachment: att_output.GIF
(Size: 60.28KB, Downloaded 1437 times)

[Updated on: Tue, 05 August 2008 08:36]

Report message to a moderator

Re: Printing Report on papers [message #338686 is a reply to message #338621]

Tue, 05 August 2008 11:35

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

Senior Member
Account Moderator

One more idea: open repeating frame's Property Inspector window and set "Maximum Records per Page" value to 1.

Report message to a moderator

Re: Printing Report on papers [message #338894 is a reply to message #338686]

Wed, 06 August 2008 03:57

esraa90
Messages: 63
Registered: May 2008
Location: EGYPT

Member

Thanks for your help.

Also, I've maximum record per page set to 1 fro employees frame.

The problem is why page2 comes on same papaer with page1?

The report parameters feels with two pages and separate records,
but both (1,2) pages come on same paper.

Report message to a moderator