Eclipse Community Forums: BIRT » Display Data in a row separated by a comma

Help

Home

Home » Archived » BIRT » Display Data in a row separated by a comma

Show: Today's Messages :: Show Polls :: Message Navigator

Display Data in a row separated by a comma [message #934162]

Fri, 05 October 2012 18:13

Vani Ra

Messages: 11
Registered: September 2012

Junior Member

Hi,

My understanding of a table is when there is a data in a column, it is shown vertically with a number of rows.

I want to display the data in horizontal way separated by a comma.. So say my query returns me 12 rows, so instead of having 1 column and 12 rows, I want the data to be displayed in one single row each separated by a comma or similar..

Is that even doable ?

Thanks

Report message to a moderator

Re: Display Data in a row separated by a comma [message #934204 is a reply to message #934162]

Fri, 05 October 2012 18:58

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

You could do this with a crosstab or just hide or delete the table detail row and add an aggregation element to the table footer and use the CONCATENATE function. See attached report for an example of both approaches.

Jason

Attachment: concathidedetail.zip
(Size: 2.31KB, Downloaded 251 times)

Report message to a moderator

Previous Topic:	How to import BIRT report on Sugar CRM?
Next Topic:	birt kills tomcat randomly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 12:31:04 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter