Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total In The Grroup Footer

Status
Not open for further replies.

RamHardikar

Programmer
Feb 16, 2001
109
GB
Hello,

In the report I am suppressing the detail part of the group and just displaying
the footer for that group. Now I want the running total (have a look at the example below)
for the footer. Now when I do this and if my records go beyond the first page then the
running total for this first row in the new page shows a discrepancy.

For eg:
Name Mon Tue Wed Thu Fri Sat Sun RunningTotal
x 1 2 3 4 5 6 7 28
y 1 2 3 4 5 6 7 28
z 1 2 3 4 5 6 7 28
--------------------------------------------------------
Total 84
--------------------------------------------------------

This works if I run the report in the Crystal Report. But when I run the same report
in the browser using Crystal Report component I have a missmatch in the total of the
first row
 
RamHardikar: It would help if you could provide an example of the error you are getting. You mention that you get a mismatch in the total of the first row on page 2 - can you explain what you expected and what you actually get and what the difference is between the result in CR and in the RDC David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
 
The things that I have seen that can throw off running totals are the 2 features of the change group expert:

Repeat Group Header on each new page
or
Keep Group Together.

These particularly affect version 7, but can bite any version if you are using manually incremented variables to do your running totals.

It would help to know your version and the code for your running total. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top