Home » Developer & Programmer » Reports & Discoverer » Carry forward TOTALS(Cumulative Total) (Reports 6i)
Carry forward TOTALS(Cumulative Total) [message #302785] Wed, 27 February 2008 00:42 Go to next message
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

Re: Carry forward TOTALS(Cumulative Total) [message #302854 is a reply to message #302785] Wed, 27 February 2008 03:21 Go to previous messageGo to next message
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,
Re: Carry forward TOTALS(Cumulative Total) [message #304426 is a reply to message #302785] Wed, 05 March 2008 02:58 Go to previous message
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
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:
  


Current Time: Sun Dec 11 04:17:18 CST 2016

Total time taken to generate the page: 0.14763 seconds