This is the report description:

report is grouped on:

Quarter (startdate of event, printed for each quarter)
Status of event
EventID


All fields, from various tables, are are placed in GH3a (eventID), showing event details
GH3b has a three field labels from event_changes table
Details section has the three fields from event_changes table, detailing what may have changed in this record during a parameter filled date

I have had major issues with this report and running totals in GF2 and GF3, where the RT's are reading the event fee for each record times as many instances of change (this could be three, four or five times!).  The problem with this is that that fee is only being charged once, not 3, 4, 5 times, so the running totals are significantly off. 

In GF2, I was able to use a RT on Event.Fee, evaluating it on change of group EventID and resetting it on change of status, and avoid dup fee addition. 

To avoid using running totals and experiencing this issue, I created a formula to sum the eventfee field if quarter and status equaled what I needed them to (example:
If {LookUp_ContractStatus.ContractStatusID}=3 or {LookUp_ContractStatus.ContractStatusID}=6 then
    {Event.Fee}).

I then did a RT on this field summing it by evaluating it on change of field eventID and resetting it on change of group quarter.  This has worked fine for GF3 to avoid dup fee addition. 

My major issue now is the report footer.  I need to sum the Event.Fee across all statuses for each quarter...this will not return the correct value by using any combo of evaluating on groups/fields and resetting on groups/fields.  It always adds multiple values wherever there is more than one record in event_changes.  I am at a loss here on how to proceed. I also need to sum all event.fees for the time parameter I enter in a separate field.  None of these needs can be met.  Any help is appreciated.

Here's a sample for a small date range.

I'm afraid I don't understand.  How do I determine whether or not yo use Previous or Next...the totals I need to see differ based on which of these I use.

can you post the detail level data and show how you want it summed?

Edited by DBlank - 19 Apr 2010 at 4:24am

Sorry. It is really hard to tell the row level data in that post. Example that there appears not to be a display of the eventg id which is key to the way your RTs are functioning. Also it appears that you have all the dupe rows already suppressed which makes it hard for me to see what the real data looks like, not this already altered version. In order for me to create an RT I have to understand the full scope of the data and how it is grouped, not just how it is currently displayed.