How do I concatenate a single field from multiple rows in BOXI 3.1 WebI?

Adding a link was more helpful...http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html

one should not take credit of what she has not done.. 😊

use ReportFilter([State])

hi,

What is the structure of your report(rows and columns)?.

Post the screen shot of what you are looking for?

Thanks,

Jothi

Hi John,

You may also try to use these option to format the cells :

In the Properties pane: check "autofit width" and "autofit height" and then "wrap text" boxes .

I hope it helps.

Fadoua

Hi Jothi, Having trouble adding an image - what formats does this forum take?

Thanks,

John

Hi

It is fantastic article and a great solution, I have been looking for this for a while – I am happy finally I got it …

In the first place i don't understand why developers find it difficult to include an aggregate function that should combine Text fields in group by (',' or ';' or 'space' or whatever) just like sum function adds up all numeric fields in a group.

The above solution is very thoughtful and works very well, but the last trick in the procedure doesn't always results in the desired output; i don't understand why we should use this trick instead we can reset the concatenate process in each [Line].

[VAR Concat Category] = [Category] +", "+ Previous(Self;([Lines]))

This will rest the concatenate in each [Line], so the last (max) running concatenate could be taken for each LINE without the need for the last variable in the above solution [VAR Category]

Hi John,

This article is really very useful. But I am working on BO 4.1 and the variable [VAR Concat Category] = [Category] +", "+ Previous(Self) is not giving the result the way it should have.

I have also attached the screen shot. Please help me out , as i have to implement this logic in some other report.

In below scenario i have 20141109,20141574 Po Num For same exped date (05-08-14)

But i want to display it as below

the above function doesn't work in this scenario......Pls Help

This is great for a standard table, but it doesn't work with a cross tab. I need a true aggregate. I've tried using WM_CONCAT() around an object, but Webi thinks it's a regular Dimension and not an Aggregate (even though I've selected it as such). The problem is that it throws it into the GROUP BY and that throws an error. I've tried surrounding that statement with an aggregate function Webi recognizes like MIN/AVG, but then it splits it out into two queries for some reason instead of a single one.

I just need a way to overwrite it and say "no matter what you think, do NOT include this in the GROUP BY". Is that possible?