Skip to Content
0
Former Member
Apr 05, 2011 at 04:22 PM

Concatonating results

12 Views

I'm using Crystal Reports 2008 to bring back these two columns of data.

Because of the format of the data in the tables my current output looks similar to this example:

Bike Frame Size               Bike Name           Supplier
18"                          BlueBike1           ABC Bikes
18"                          BlueBike2           ABC Bikes
17"                          RedBike1            XYZ Bikes
17"                          RedBike2            XYZ Bikes
17.5"                        OrangeBike1      BikesRUs
16"                          PurpleBike1        Great Bikes
16"                          PurpleBike2        Great Bikes

What I am trying to achieve is to have the output look like this:

Bike Frame Size               Bike Name                     Supplier
18"                         BlueBike1, BlueBike2           ABC Bikes
17"                          RedBike1, RedBike2            XYZ Bikes
17.5"                       OrangeBike1                    BikesRUs
16"                          PurpleBike1, PurpleBike2      Great Bikes

I'm certain there must be a way of grouping these results using the Formula Workshop but I cant get a handle on it. Any pointers..??

Edited by: Matt_Owen_176 on Apr 5, 2011 6:31 PM

Edited by: Matt_Owen_176 on Apr 5, 2011 6:32 PM

Edited by: Matt_Owen_176 on Apr 5, 2011 6:33 PM