Summarizing Issue

[marcyeager]

I am working on a report where I have 2 groups. The first group is grouping the report by month. The second group is grouping the records by record number, since each record has multiple transactions.

Where i'm running into an issue is being able to sum the numbers of a particular formula field inside of the second group. I am able to sum all of the database fields correctly as they are distinct records, but because the formula field is calculated based on the record number not each transaction for the record number my sum is considerably higher than it should be.

I was wonder if anyone had any tips on how to configure this to give me the correct sum of this formula field.

Thanks, Marc

 

[lbass]

Insert a running total that sums the formula, and in the evaluation section, choose evaluate on change of group: {table.recordnumber}. If you are summarizing at the month group level, choose reset on change of group: {table.month}. Create a separate running total for the grand total, with reset = never. Place the running totals in the group footer or report footer sections respectively.

-LB

 

[synapsevampire]

In the group footer for record number place:

whileprintingrecords;
numbervar MyTot:=MyTot+1

Then in the month group footer place:

whileprintingrecords;
numbervar MyTot;
totext(month({table.field}),0,"") + ": " + totext(MyTot,0,"")

-k

 

[marcyeager]

Should I put putting those two strings in as formulas in the footer?