Group sort on summary field
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=877
Printed Date: 27 Apr 2024 at 9:07pm
Topic: Group sort on summary field
Posted By: GreyDog
Subject: Group sort on summary field
Date Posted: 19 Jun 2007 at 2:09am
|
Hi,
I'm working on another report now and have another question about sorting and groups.
This time the report looks like
Rep Account Jan-07 Feb-07 ... Nov-07 Dec-07 AccountTotal
08 AAAAA 500 263.45 0 0 763.45
08 BBBBB 0 100 0 0 100
totals 500 363.45 0 0 863.45
06 CCCCC 450.50 230.10 0 0 680.60
06 DDDDD 1234 1110 0 0 2344
totals 1684.50 1340.10 0 0 3024.60
And so on for the rest of the reps.
The grand total for each rep is a summary field.
I've got the report grouped by Rep and then using the group sort expert, sorted by the grand total.
This is nearly what I need. the only problem is that the summary field seems to be picking up on suppressed and non-suppressed fields. therefore some of the grand totals aren't correct and the sort order is wrong.
So i have a few questions
1) Is there anyway to get a summary field to ignore suppressed data?
2) Can I use any other type of field with group sort expert? (I've tried running totals and formula fields but it doesn't seem to like them)
If not does anyone have any suggestions how else to sort the data?
Thanks
|
Replies:
Posted By: GreyDog
Date Posted: 19 Jun 2007 at 7:15am
|
I found something that said that summaries are run in the first data pass and the detail in the second. So they ignore whether data is suppressed or not. So i've managed to modify the selection formula so that there are no records that need to be suppressed and now the summary field/sort order is ok.
 |