OraFAQ Forum: Reports & Discoverer » how to change from Portrait to landscape report

Home » Developer & Programmer » Reports & Discoverer » how to change from Portrait to landscape report (Oracle Report Builder 10g)

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

how to change from Portrait to landscape report [message #518823]

Sun, 07 August 2011 15:26

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

I am modifying one report which was in Portrait fashion. Now I had added more details and make the report to print in Landscape fashion. I had changed the parameters of header, body and trailer under Page Output heading in Oracle Report builder 10g. like making width 11, height 9.5 and printing fashion as Landscape. But I am having a problem. The report is printing in landscape but half of the report came on the paper and half remain empty. I have tried to adjust the scale but this didn't help me. Can I correct this report or I have to make new one with landscape fashion from the beginning?

i can send the report if someone really want to see.

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518835 is a reply to message #518823]

Mon, 08 August 2011 01:16

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

Senior Member
Account Moderator

You set "paper size" to be landscape; now you have to (manually) readjust frames and fields so that they reflect that paper orientation. Reports Builder won't do that automatically.

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518848 is a reply to message #518835]

Mon, 08 August 2011 01:56

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

i have changed the frames sizes and positions and the report is printing in landscape fashion but half of the report does not print on the paper. the report doesnt give any error like something is outside the frame. And I forget to mention that if i changed the orientation of the paper in Page Setup it works very fine. but this problem arises when i run the report from Oracle Forms i mean through some procedure.

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518855 is a reply to message #518848]

Mon, 08 August 2011 02:30

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

Senior Member
Account Moderator

Quote:

half of the report does not print on the paper

Which half? Right? Bottom?

Did you (in Reports Builder - Object Navigator - Data Model - System parameters - Orientation) set value to "Landscape"?

As of Forms: how do you call the report? Did you set the ORIENTATION parameter?

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518857 is a reply to message #518855]

Mon, 08 August 2011 02:58

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

the left half. the report comes to paper with some blank space and then the right part (Start portion) of the report.

this parameter set as default. I didn't change anything in it. I changed only the parameters (like width, height and orientation) in the header, main, trailer section under Paper layout.

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518867 is a reply to message #518857]

Mon, 08 August 2011 03:21

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

The image

Attachment: IMAG0033.jpg
(Size: 848.74KB, Downloaded 2927 times)

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518868 is a reply to message #518857]

Mon, 08 August 2011 03:21

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

Senior Member
Account Moderator

Change "default" to "landscape" (I'm not saying that it'll fix the problem, but that's what you really SHOULD do).

What about the rest of my question?

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518871 is a reply to message #518868]

Mon, 08 August 2011 03:30

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

Please see the image so that you will be more clear what my problem is.

ok i will do that thing. and the procedure is also taking care by changing that orientation parameter. there is no problem with printing landscape, it is printing in landscape fashion but half of the report only printed.

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518878 is a reply to message #518871]

Mon, 08 August 2011 04:04

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

Senior Member
Account Moderator

The image you attached: it appears that the whole "output" should be moved right. I don't know what might be the culprit here ... do other documents (for example, from MS Word or PDF) whose orientation is "landscape" print correctly? Did you install the latest driver?

Report message to a moderator

Re: how to change from Portrait to landscape report [message #518888 is a reply to message #518878]

Mon, 08 August 2011 04:47

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

yes everything is perfectly fine. some other reports are also working fine with same everything. As I mentioned early that when I set the Landscape fashion in (File -> Print Preview -> Page Setup) then the report comes out fine. Anyways thanks for your concern i think i had to shrink the report and make it Portrait.

Report message to a moderator

Re: how to change from Portrait to landscape report [message #541606 is a reply to message #518888]

Wed, 01 February 2012 05:26

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,

I too am facing a similar problem. i have identified where the problem is, but i am not able to edit the page size.

In paper layout i changed the page size in header, main and trailer section A4 to A3 size . My original report was in A4 size where the report width was 80 for A4 size . i made it as 132 and the changed the layout also accordingly.

But in the data model > system parameters > orientation the width shows 80 and hence when i print it only prints till the a4 size and left is not getting printed.

It does not allow to edit the width in system parametes. could any one help me out in this matter.

thanks in advance

Report message to a moderator

Previous Topic:	Error message when passing the report parameter from command line
Next Topic:	SQL Union All

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 00:41:32 CST 2024