Skip to Content
0
Nov 06, 2008 at 04:15 PM

Can Webi format names like this?

14 Views

Hi all

I'm struggling with a reporting problem with Webi (this can be done with Crystal, however would prefer webi first).

I have a table of data where the data in one of the columns needs to be concatenated. Here is an example of what I have:

Trade ID Name Amount Traded

1000 B Skipper 50

1000 P Hose 50

1100 F Franks 100

1200 F Franks 100

1200 D Dodds 100

1200 B Skipper 100

Total of 3 trades

Total Amount Traded = 250

I want to see one row per trade ID and amount with the names asscociated with the trade concatenated. This is what I want to see:

Trade ID Name Amount Traded

1000 B Skipper;P Hose 50

1100 F Franks 100

1200 F Franks;D Dodds;B Skipper 100

Total of 3 trades

Total Amount Traded = 250

I've tried a variety of things however cannot get this right.

Has anyone done this before and if so please could you create me a simple example using eFashion in a BIAR file.

Thank you and kind regards,

Dean Farrow