Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Sorting Post Reply Post New Topic
Author Message
patil
Newbie
Newbie


Joined: 19 Apr 2010
Online Status: Offline
Posts: 16
Quote patil Replybullet Topic: Sorting
     Posted: 17 Jun 2010 at 2:26am
Hi All,
In my report there are 3 groups ..
1st group:name
2nd group:age
3rd group:region 
and i want to sort by region and then by name..
 
i am trying to do in record sort expert but the buttons are not enable..
 
PLZ can anyone tel me how to sort by using formula or by other way???
IP IP Logged
SrVickers
Newbie
Newbie


Joined: 25 Jun 2009
Location: United States
Online Status: Offline
Posts: 10
Quote SrVickers Replybullet Posted: 17 Jun 2010 at 2:42am
Place your group in the order you want the report to sort . Move group:region to the top.
Stephen
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 17 Jun 2010 at 2:48am
try to help.
 
you can change the group by right click the group and change it
 
or
 
1. create a formula contains:
    (assume: region_var is string)
    xx=region_var + name
2. make a group based on this formula (xx) and delete the field
3. put the region_var on the group section
    so it will print the region only (without name)
 
 
hope it help.
glad if it is.
 
 
Emir W
IP IP Logged
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