Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Groupings in Report Footer?

Status
Not open for further replies.

Bennie47250

Programmer
Nov 8, 2001
515
US
Using Crystal version 7.0

Is it possible to do groupings in the report footer?

My situation is: We have a monthly accounts receivables reports that shows receivables for our 20 or regions. We have shown totals for all the regions in the Report Footer.

Management then asked to show the previous month total only. To do this I inserted another report footer and wrote a set of formulas to calculate this.

Well management got the report and then decided it would be awesome if the report could also show not just the previous month total but all previous months total, in descending order no less.

Short of creating a set of formulas for each month in the Report footer, if it is possible to group in the footer my problems would be resolved.

Can this be done?

Any other thoughts on how to do this with out writing formulas for each month?

Thanks
 
Currently you cannot group off the report footer, thus restricting your grouping to details only. Depending on how you have your report setup, you may be able to group via a date and select monthly.. with your totals being displayed in the group footers. An option to simulate your "page footer grouping" could be a subreport with your details in it in the report header, then the group footers of the main report displayed below that with the group headers/detail section of the main report suppressed. This would allow you to effictively display a per month grouping.
Cheers,
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com
 
Now that is an interesting thought. I will give the subreport idea a try

THANKS [2thumbsup]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top