asked on

Running Total by Maximum Date

Hi Experts,

I have 2 Group Footers GF1 and GF2...I have a subtotal per each of these...Per detail line I have Various Dates...I need to summarize at the Report Footer the summary by Maximum of the MonthName of the Dates..

01/19/2014
01/14/2014
02/05/2014

I need to have the GF2 subtotal associated with the MonthName of 02/05/2014 and Show a Grand total of that value based on 'February'

Hopefully this makes sense

Mike McCracken

WHat are your groups?

How is the group total different from the value associated with the date?

mlmcc

Michael Katz

ASKER

Group 1 is a Salesperson
Group 2 is a SalesOrder

The Group 2 is not a date field...I currently have a summary on a date field to give me the Maximum(Date) and it resides on the GF2 line

Michael Katz

ASKER

Maybe the best solution is just to create a subreport based a group of The Max Podate

Mike McCracken

Do you need the details from the other dates?

mlmcc

Michael Katz

ASKER

Yes...I need the details from the other dates

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

James0628

Are you trying to get a single total in the report footer for the latest date (Month?) on the report, or something else?

James

Mike McCracken

In the problem statement he needs it in GF2.

mlmcc

James0628

Actually, in the first part of his first post he says "I need to summarize at the Report Footer", and then near the end says "Show a Grand total". So, I'm really not sure what he's looking for.

James

Michael Katz

ASKER

Hi guys,

I just created a subreport...works