Summary on a group field
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16639
Printed Date: 04 May 2024 at 3:43am
Topic: Summary on a group field
Posted By: 4sue2c
Subject: Summary on a group field
Date Posted: 30 May 2012 at 5:10am
Hi, I have a sales report with numbered fields in a group footer and I would like them to be totaled how can I do this or can I? I have a total of three group fields, the list below is not part of the details section. The Details section has other data. I'm a novice please help! GF1 Sales Man GF2 Industry GF3 Customer YTD LYS MTD Mass Ltd. 100 250 50 Dealer Ltd. 500 300 100 Bla Bla Inc. 600 300 250 |
Replies:
Posted By: DBlank
Date Posted: 30 May 2012 at 5:30am
| are these values calculated in the report or did you just drag and drop them into the report footer? |
Posted By: 4sue2c
Date Posted: 30 May 2012 at 5:40am
| No, I had to drop them in. |
Posted By: DBlank
Date Posted: 30 May 2012 at 6:20am
|
so basically you want a YTD,LYS and MTD total at the Industry group level and the value in your dataset are per row so it repeats for each detail row, correct?
You can use Running Totals or shared variables to get the values. Both need to be placed in group footers (if placed in a header it will not show the correct values).
I prefer Running totals so here is an example of that:
Right click on RT fields in the field explorer and select new
Name=YTD_Industry
field to summarize=YTD
Type=Sum
Evaluate= on chneg of group (select group 3-customer)
reset= on change of group (group2-inustry)
OK
drag and drop onto GF2
|