OraFAQ Forum: Reports & Discoverer » How to display a subtotal of the previous page?

Home » Developer & Programmer » Reports & Discoverer » How to display a subtotal of the previous page?

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

How to display a subtotal of the previous page? [message #164055]

Tue, 21 March 2006 09:23

jsulc
Messages: 19
Registered: October 2005

Junior Member

I need to print the subtotal of the previous page on the top of the current page. Is it possible???
Thanks you all.
Mad

Report message to a moderator

Re: How to display a subtotal of the previous page? [message #164078 is a reply to message #164055]

Tue, 21 March 2006 12:31

spinky
Messages: 21
Registered: March 2006

Junior Member

Hi,

Yes its possible..Create a frame around the SubTotal
field(s)..Set the "Page Break Before" property of the frame to "YES"..Hope this solves your problem..

Report message to a moderator

Re: How to display a subtotal of the previous page? [message #164165 is a reply to message #164078]

Wed, 22 March 2006 02:19

jsulc
Messages: 19
Registered: October 2005

Junior Member

Thanks but the problem is different.
This is my page layout:

--Start of page--

Subtotal from previous page: 140.000

Invoice No.xxx 11.000
Invoice No.xxx 10.000
Invoice No.xxx 10.000
Invoice No.xxx 10.000

Subtotal: 181.000

--Page break--

Subtotal from previous page: 181.000

Invoice No.xxx 1.000
Invoice No.xxx 2.000

Subtotal: 184.000

--Page break--
etc.....

Of course, I can make subtotal of current page.
But how to get subtot. of the previous one?
In Crystal Reports you can use global variable for storing the value. Is it the right way to do it also in Oracle Reports???

Thanks for help.
jsulc

Report message to a moderator