Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Group sort on summary field Post Reply Post New Topic
Author Message
GreyDog
Newbie
Newbie
Avatar

Joined: 13 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 11
Quote GreyDog Replybullet Topic: Group sort on summary field
    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
 
IP IP Logged
GreyDog
Newbie
Newbie
Avatar

Joined: 13 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 11
Quote GreyDog Replybullet 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.Smile
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.