Home » Developer & Programmer » Reports & Discoverer » pagebreak based on condition
pagebreak based on condition [message #157697] Sat, 04 February 2006 03:05 Go to next message
supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad
Member
Hi all,

i created group above report by using the following query

select oh.ord_no,ord_qty from ordhead oh,ordline ol where oh.ord_cntrl_no=ol.ord_cntrl_no

which given me the output as

ordno 1
qty 10
20
30
ordno 2
qty 300
400

and so........

my requirement is for every ordno i need a pagebreak.

like

page 1...........

ordno 1
qty 10
20
30

page 2 .........

ordno 2
qty 300
400

etc...

thanks in advance,
supriya


Re: pagebreak based on condition [message #157698 is a reply to message #157697] Sat, 04 February 2006 03:13 Go to previous messageGo to next message
supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad
Member
sorry, its in developer reports 9i

thanks,
supriya
Re: pagebreak based on condition [message #160925 is a reply to message #157698] Wed, 01 March 2006 00:58 Go to previous message
karthi
Messages: 42
Registered: December 2000
Location: B'lore
Member

Hi Supriya,

Advance Happy B'day to you on 4th.
In tht frame set page break as true in the properties, thn it will print per page.

bye
Karthik
Previous Topic: How to Set Width at Runtime?
Next Topic: Faster Reports
Goto Forum:
  


Current Time: Fri Jun 28 15:41:04 CDT 2024