Print Page | Close Window

how to concatenate hard coded values in 1 row

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10832
Printed Date: 01 May 2024 at 11:52pm


Topic: how to concatenate hard coded values in 1 row
Posted By: flintwood
Subject: how to concatenate hard coded values in 1 row
Date 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


Replies:
Posted By: hilfy
Date 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
 


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: flintwood
Date Posted: 19 Aug 2010 at 11:47am
Thanks for the idea buddy!!. i'll try it out

-------------
FW


Print Page | Close Window