Hi. Not sure how to explain this, but here goes. I have a report that has 2 groups:
Group 1 - Result 1
Group 2 - Result 1
Record 1
Record 2
Record 3
Group 2 - Result 1 Summary
Group 2 - Result 2
Record 1
Record 2
Group 2 - Result 2 Summary
Group 1 - Result 1 Summary
Group 1 - Result 2
Group 2 - Result 1
Record 1
Group 2 - Result 1 Summary
Group 1 - Result 2 Summary
Grand Total (in footer)
So, now what I need to do is get a summary for all records in Group 2 - Result 1 only, regardless of which Group 1 they fall in and get it to show in the report footer. I can get this if I switch the order of my groups.
To complicate matters further, my existing group summaries are formulas that combine other summary formulas and running totals. I couldn't do normal summaries because my data returns multiple records that duplicate the data I am trying to sum.
Sorry for the long email. Can anybody push my in the right direction?
Thanks,
Skystar
Group 1 - Result 1
Group 2 - Result 1
Record 1
Record 2
Record 3
Group 2 - Result 1 Summary
Group 2 - Result 2
Record 1
Record 2
Group 2 - Result 2 Summary
Group 1 - Result 1 Summary
Group 1 - Result 2
Group 2 - Result 1
Record 1
Group 2 - Result 1 Summary
Group 1 - Result 2 Summary
Grand Total (in footer)
So, now what I need to do is get a summary for all records in Group 2 - Result 1 only, regardless of which Group 1 they fall in and get it to show in the report footer. I can get this if I switch the order of my groups.
To complicate matters further, my existing group summaries are formulas that combine other summary formulas and running totals. I couldn't do normal summaries because my data returns multiple records that duplicate the data I am trying to sum.
Sorry for the long email. Can anybody push my in the right direction?
Thanks,
Skystar