Print Page | Close Window

Merging multiple rows into one Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22627 Printed Date: 01 May 2024 at 5:30pm Topic: Merging multiple rows into one Posted By: Funkyboz Subject: Merging multiple rows into one Date Posted: 14 Jun 2018 at 8:29pm Good day all I am a newbie on Crystal Reporting especially the advance part. I designed a report that pull data from a MS SQL database and having issue with the formatting of data. current format; Sample_Grouping AQ_LN1 OR_LN1 AQ_LN2 OR_LN2 Ext 5                     0.172 Ext 5            0.018 Ext 5                                  0.246 Ext 5                          0.026 I grouped the data by "Sample_Grouping" and would want to appear as one row as; Sample_Grouping AQ_LN1 OR_LN1 AQ_LN2 OR_LN2 Ext 5       0.018  0.172   0.026  0.246[ ------------- Regards Funkyboz Replies: Posted By: kevlray Date Posted: 15 Jun 2018 at 7:18am I think you can create a crosstab, but then I do not use crosstabs enough to be sure.  Otherwise is to group by the sample grouping and have a formula that builds a string with the values.  It would be a little tricky since the fields could be null (have to put in null checks).

Print Page | Close Window