Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: how to concatenate hard coded values in 1 row Post Reply Post New Topic
Author Message
flintwood
Newbie
Newbie
Avatar

Joined: 31 Jul 2010
Online Status: Offline
Posts: 16
Quote flintwood Replybullet Topic: how to concatenate hard coded values in 1 row
    Posted: 13 Aug 2010 at 10:58am
I have a little complex situation here. i have regluar columns and then some hard coded coulumns. First few columns have customer info, Id, and name. next few columns are customized. month1 to month6. under each month a sequence number has coded to "1" represent month one. So if the first digit of the sequence # is 1 then it falls under month1, if first digit is 2 then it falls under mont2 and the same until month6. Now the sequence number appears twice for the same customer, but also want the other sequence numbers under all the months in the same row as well for all different combinations. How is that possible.
 
this is what it shows:
 
 
 
Id     Name              Month1     month2            month3
 
1      abc                  1345         
1     abc                                    2567              
1     abc                                                           3567
1     def                                                            3569
1
 
 
 
 
 
 
this is what i want:
 
Id     Name              Month1     month2            month3
 
1      abc                  1345         2567               3567
1     def                    1346        2567               3567
1     ghi                    1345        2568                3567
1    jkl                       1345       2568                 3569
 
 
Any  ideas? Really need some help!
      
FW
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Aug 2010 at 11:12am
Assuming you're using formulas to get the sequence numbers into the correct columns and that there will only be a single value for any given month for each name, try this:
 
1.  Group by Name.
2.  Suppress the details section and put your customer info into the Group Footer section.
3.  For each month, create a summary that is the Max of that month's sequence number for the Name group.
 
-Dell
 
IP IP Logged
flintwood
Newbie
Newbie
Avatar

Joined: 31 Jul 2010
Online Status: Offline
Posts: 16
Quote flintwood Replybullet Posted: 19 Aug 2010 at 11:47am
Thanks for the idea buddy!!. i'll try it out
FW
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.