• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

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
0
Mikeyman_01
Asked:
Mikeyman_01
  • 4
  • 4
  • 2
1 Solution
 
mlmccCommented:
WHat are your groups?

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

mlmcc
0
 
Mikeyman_01Author Commented:
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
0
 
Mikeyman_01Author Commented:
Maybe the best solution is just to create a subreport based a group of The Max Podate
0
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
mlmccCommented:
Do you need the details from the other dates?

mlmcc
0
 
Mikeyman_01Author Commented:
Yes...I need the details from the other dates
0
 
mlmccCommented:
Try this idea

Add a third group on the date field
You don't need to put anything in the group header or footer except a formula that calculates the group total and saves it in a variable.  You can then display the total (through the variable) in the next group footer

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

 James
0
 
mlmccCommented:
In the problem statement he needs it in GF2.

mlmcc
0
 
James0628Commented:
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
0
 
Mikeyman_01Author Commented:
Hi guys,

I just created a subreport...works
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now