Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: How to display age range i.e 0-5,6-10,....? Post Reply Post New Topic
Author Message
SunilKanta
Newbie
Newbie
Avatar

Joined: 05 Jun 2007
Location: India
Online Status: Offline
Posts: 15
Quote SunilKanta Replybullet Topic: How to display age range i.e 0-5,6-10,....?
    Posted: 05 Jun 2007 at 9:11am
Hi,
 
I am new to crystal reports, i am designing a report i.e cross tab report as shown below,
 

AGE TABLE

0-5

6-10

11-15

16-20

21-25

26-28

CLASS A Count

                   -  

               -  

               -  

               -  

                 7

               15

CLASS B Count

                   -  

               -  

               -  

               -  

                 7

               15

CLASS C Count

                109

             155

             120

               96

               89

               -  

 
Now my questions are,
 
How to display age ranges i.e 0-5, 6-10,........?
 
How to group ages in range and get the count or any summarized value ?
 
Here i am passing three parameters to the report which are
1. prmLowAge
2. prmHighAge
3. prmAgeBand
 
Above shown sample is characterised with prmAgeBand = 5, prmLowAge = 0 and prmHighAge = 28.
 
And if possible please try to find the solution for variable age bands.
 
Please i am very desperate. Please help me in solving thisCry.
 
 


Edited by SunilKanta - 05 Jun 2007 at 9:17am
Thanks,
Sunil
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 05 Jun 2007 at 10:51am
I would create a formula that returns the age band based on the current age. Then use the formula in a cross-tab object as the column field.

select {table.field}
    Case 1 to 5:
        "0-5"
    Case 6 to 10:
        "6-10";

Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
SunilKanta
Newbie
Newbie
Avatar

Joined: 05 Jun 2007
Location: India
Online Status: Offline
Posts: 15
Quote SunilKanta Replybullet Posted: 05 Jun 2007 at 9:16pm
Thanks! Buddy,
 
I'll try that out, you saved me from great disaster!!
Thanks,
Sunil
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 05 Jun 2007 at 10:58pm
I would hate for any great disasters to happen to you. 
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.