Concat Rows part 2...
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=2432
Printed Date: 02 May 2024 at 9:04am
Topic: Concat Rows part 2...
Posted By: mdmendoza
Subject: Concat Rows part 2...
Date Posted: 25 Feb 2008 at 7:09pm
hello guys! i have another more problem... in my previous, i need to concatenate two(2) distinct item... here's my problem... what if there are two or more distinct item? here's an example...
ID Name Time In
1 Mike 8:00
2 Jim 8:50
3 Terry 9:00
1 Mike 9:09
1 Mike 9:10
1 Mike 9:20
i expect to have this result:
ID Name Time In
1 Mike 8:00, 9:09, 9:10, 9:20
2 Jim 8:50
3 Terry 9:00
thanks! ~,~
|
Replies:
Posted By: hilfy
Date Posted: 26 Feb 2008 at 12:28pm
|
You're going to have to make sure that your data is grouped/sorted so that all of Mikes records are together. You can then use the same method that was discussed in the previous post.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|