Invalid totals if more than one sum formula into Group Header.

[janardan]

Hi All,
When I use more than one summary function into group header then it is giving wrong totals.
actually I have to show the totals of three fields in header. And I have four tables from where this all data is coming. the relation is like 1-2,1-3,1-4. I am using three formulas (sum({Amount}) etc)
If i only put one formula in header then it is showing correct sum but if i put more than one formula into header then the total increases a lot.
Please help.

Janardan

 

[dgillz]

From the design window, just right on the fields you want totals, and select insert summary. Choose the summary field and the totals are created.

By default crystal will place these objects in the group footer. Just drag them to the group header and you are done. No formula required. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com