Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Grouping values Post Reply Post New Topic
Author Message
Aarav
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 12
Quote Aarav Replybullet Topic: Grouping values
    Posted: 26 Oct 2010 at 8:33am
I need to design a report where I have to split the values in 3 categories.
 
There is a tracking number with adults, children and adult and children.
 
My Report current shows:
 
Tracking Number      Categories
1                               Child
1                               Child
 
2                              Child
2                              Adult
 
3                              Adult
3                              Adult
 
I would like to see the report in this format:
 
Child
Tracking number 1
                           5
                           10
 
Adult                2
                        6
                        9
Child and Adult
                             3
                             7
                             8
 
Also, categories is the variable I made to comibine valuses.
 
Pleae help..
 
IP IP Logged
Aarav
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 12
Quote Aarav Replybullet Posted: 27 Oct 2010 at 3:06am
Can Someone please help me?
IP IP Logged
judylynn
Newbie
Newbie
Avatar

Joined: 17 Nov 2008
Location: United States
Online Status: Offline
Posts: 22
Quote judylynn Replybullet Posted: 28 Oct 2010 at 8:22am
I think you need to give more information. What do the numbers 5,10, etc.. signify in the example?
IP IP Logged
Aarav
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 12
Quote Aarav Replybullet Posted: 29 Oct 2010 at 10:02am
Here is the database values:
 
Field1                         field 2                                        field3
chp 10-13937           child name#1                            Processed child
chp 10-13937           child name#2                            Processed child    
chp 10-13967           childname#1                             processed child
chp10 -13967           adultname#1                            Processed Adult
chp10-18067            childname#1                             Rejected Child
chp10-18067            childname#2                             Rejected Child
MCW10-20012          adultname#1                           Rejected Adult
MCW10-20012          adultname#2                           Rejected Adult
 
I created variable which stores processed child or rejected child as child and processed adult or rejected adult as Adult with using if and else category.
 
I want to see the result as follows:
 
Child
 
chp 10-13937  
chp10-18067
 
Count:2
 
Adult
MCW10-20012
Count:1
 
Adult and child
chp 10-13967
Count:1
 
 
 
 
 
 
 
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.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.