Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Display Data in a row separated by a comma
Display Data in a row separated by a comma [message #934162] Fri, 05 October 2012 18:13 Go to next message
Vani Ra is currently offline Vani RaFriend
Messages: 11
Registered: September 2012
Junior Member

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 ?

Re: Display Data in a row separated by a comma [message #934204 is a reply to message #934162] Fri, 05 October 2012 18:58 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
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.

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

Current Time: Sat Jan 28 07:27:00 GMT 2023

Powered by FUDForum. Page generated in 0.10985 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top