Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Group Header Post Reply Post New Topic
Author Message
reddy1868
Newbie
Newbie


Joined: 20 May 2010
Online Status: Offline
Posts: 5
Quote reddy1868 Replybullet Topic: Group Header
    Posted: 22 Sep 2010 at 10:01am

Hi Gurus,

I am using Crystal Reports 2008. I have a scenario like this. I have a Group Header based on ‘Continent’ Field. Right now, it displays the data like this

Continent          Population (These two are placed in Group Header and grouping is based on Continent)

Europe               10M

Asia                     50M

North America    6 M

South America    5M

 

The user requests the data should be displayed as mentioned below

Continent          Population

Europe               10M

Asia                     50M

America             11M

 

(Where America = North America + South America)

 

How can I achieve this in Crystal reports 2008? I appreciate your suggestions.

Thanks,

Sukumar

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Sep 2010 at 12:09pm
create a formula
if {continent} like "*america*" then 'America' else {Continent}
use this as your group on field
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.