OraFAQ Forum: Reports & Discoverer » Report Output in Second Page

Home » Developer & Programmer » Reports & Discoverer » Report Output in Second Page

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

Report Output in Second Page [message #189736]

Sat, 26 August 2006 01:50

yram
Messages: 75
Registered: February 2001

Member

Hi

Let us consider the example to Dept table, emp table in scott schema.

I need the data to be printed in two (2) pages..

1st page

DEPTNO, DNAME ,LOC
-------
------
-------
-------
-------

2nd page

DEPTNO, EMPNO, ENAME, SAL, MGR
-------
------
-------
-------
-------
-------
------
-------
-------
-------

At any time the report should be printed in two pages..

Is this possiable ?

Pls do help me out...

Regards
Yram

Report message to a moderator

Re: Report Output in Second Page [message #237384 is a reply to message #189736]

Mon, 14 May 2007 05:54

malakolama
Messages: 16
Registered: May 2007
Location: sri lanka

Junior Member

hi, i know its been a long time since you asked this question. but please let me know how you solved this problem. i am facing a similar situation.
thanks

Report message to a moderator

Re: Report Output in Second Page [message #237453 is a reply to message #237384]

Mon, 14 May 2007 09:35

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

hi malakolama,
It can be done if you could try you can solve it. Decrease the size.
AT

Report message to a moderator

Re: Report Output in Second Page [message #237465 is a reply to message #189736]

Mon, 14 May 2007 10:23

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

Senior Member
Account Moderator

So move the second querie's output to the second page! How? Select its master parent frame (by default, it should have a name like 'M_G_emp_GRPFR') and set its "Page Break Before" property to YES.

Report message to a moderator

Re: Report Output in Second Page [message #238169 is a reply to message #237465]

Wed, 16 May 2007 23:17

malakolama
Messages: 16
Registered: May 2007
Location: sri lanka

Junior Member

Thanks all.. not exactly my question.. but thanks Smile

Report message to a moderator

Re: Report Output in Second Page [message #238217 is a reply to message #189736]

Thu, 17 May 2007 02:25

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Dear,
For that What i think you should make two diffrent repaeting frames but let me know wether your Data will not not exceed more than 2 pagesc ever...if so you make first frame property of "Print Object on" as First Page and for second frame make it All but First Page.
Thanks
Jak

Report message to a moderator

Previous Topic:	can anyone solve this problem
Next Topic:	How to change display language

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 08:51:22 CST 2025