OraFAQ Forum: Reports & Discoverer » Carry forward TOTALS(Cumulative Total)

Home » Developer & Programmer » Reports & Discoverer » Carry forward TOTALS(Cumulative Total) (Reports 6i)

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

Carry forward TOTALS(Cumulative Total) [message #302785]

Wed, 27 February 2008 00:42

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,

I have report like this

first page

 deptno sal
 10     1000
 10     2000
 10     3000
  
  Total 6000

i need in the second page
 deptno sal
 20     1000
 20     2000

  Total 3000
    
GrndTot 9000 (Mean Prevous total+ this page total)

third page

deptno sal
30     2000
30     1000

 Total    3000
Grnd total 12000 (Mean 9000+3000)

Please any suggestion...

I searched in this forum also, but no solution..

any link or sample report?

Advance Thanks

Mano

Report message to a moderator

Re: Carry forward TOTALS(Cumulative Total) [message #302854 is a reply to message #302785]

Wed, 27 February 2008 03:21

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

Report Builder does not support setting a page break at a specific row of report output.

regards,

Report message to a moderator

Re: Carry forward TOTALS(Cumulative Total) [message #304426 is a reply to message #302785]

Wed, 05 March 2008 02:58

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,

I got the solution for this.. this quite simple logic only...

Assure G1 is group and having the details deptno,sal

Create on Summary column for sal in G1 Group and reset at G1

Create another one summary column for sal in G1 reset at report

Both summary columns should be in G1 group...

thats all...

Cheers....

Mano

Report message to a moderator

Previous Topic:	How can i use radio buttons in layout of report?
Next Topic:	How can used UNION STATMENT ACCORDING CONDITION in REPORT?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 03:21:58 CST 2024