Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help with Customize Group Name Post Reply Post New Topic
Author Message
eastwest
Newbie
Newbie
Avatar

Joined: 10 Jun 2009
Online Status: Offline
Posts: 6
Quote eastwest Replybullet Topic: Help with Customize Group Name
     Posted: 19 Feb 2010 at 8:54pm

Hello Everyone,

   I hava crystal report XI with a country field. I would like to group the report based on country field as follows:

Group Name
------------------
1. United States (which should include records from Peurtorico also)
2. Canada
3. Mexico
4. Others(I want to name this group as International)

Also please let me know is there a way to display the count of each group in group tree next to their group name. I don't want to display the count of each group in any section of the report.

Any suggestion is greaty appreciated.

Thanks in advance!

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Feb 2010 at 6:10pm
Create a formula field using an If-then statement to convert the string into what you want and then group on this new formula field...
If Table.country in['UNited States','Puerto Rico'] then 'UNited States' else
if Table.country in ['Canada','Mexico'] then table.country else 'Other'.
 
Can't think of any way to show a count in the group tree.


Edited by DBlank - 20 Feb 2010 at 6:19pm
IP IP Logged
eastwest
Newbie
Newbie
Avatar

Joined: 10 Jun 2009
Online Status: Offline
Posts: 6
Quote eastwest Replybullet Posted: 20 Feb 2010 at 7:33pm
Thanks a lot!!!! This is helpful.
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