A question on Totals in Crystal XI

[karnd]

Hi,

I have the report output like this so wanted to do the Totals and GrandTotals based on EachDeptName

DeptName Sections Salary
========= ========= ========
DeptName-XYZ
Section101 $1000
Section102 $2000
Section103 $3000
Others $10000
Miscellanious $20000

Total for DeptName-XYZ =======
?????
========

DeptName-ABC

few records like above

But Others and Miscellanious are rolled up values(brought from Views)and put it under DeptName-XYZ so how does i get the total for the DeptName-XYZ and also Grand Total on all DeptNames.

I tried somehow using Sum function but not getting the correct valeus.

Thanks a lot
Regards

 

[Madawc]

When you don't want to add everything, use a running total. Make it conditional, to exclude 'Others and Miscellanious', if that's what you want.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the name. The disadvantage is that they are working out at the same time as the Crystal report formats the line. You cannot test for their values until after the details have been printed. You can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.

Summary totals are cruder, but are based directly on the data. This means that they can be shown in the header. They can also be used to sort groups, or to suppress them. Suppress a group if it has less than three members, say. They default to 'Grand Total', but also can be for a group.


Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10