Can Webi format names like this?

[DeanFarrow]

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

[Former Member]

You can conactenate two column values, however combining values within the same column seems unlikely to achieve.

[Former Member]

Hi,

I am afraid but you can not achieve this.

You will see that if you remove the id and name column the table will automatically be aggregated with the first column but there is no option where you can get the other two rows to be shown in same column when you aggregate the first column.

This is definitely can not be achieved in webi.

Regards,

Gaurav