Topic: Merging multiple rows into one 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;
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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).
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
IP Logged
