Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Re: How to aggregate a string field?
Re: How to aggregate a string field? [message #503543] Mon, 14 December 2009 16:16
Eric Rizzo is currently offline Eric RizzoFriend
Messages: 3070
Registered: July 2009
Senior Member
Copying this to the BIRT forum (eclipse.birt for newsgroup readers).

On 12/14/09 6:08 AM, Jirong Hu wrote:
> Hi
>
> e.g. if a Defect has multiple attachments, when you create a query to
> list all Defects with Attachment field, the query result will have
> multiple entries for this Defect with different attachments.
>
> Now the customer want to have one entry only with all attachments in it.
> I think we can do that in a report, but how to achieve in a BIRT report?
>
> Jirong
Re: How to aggregate a string field? [message #503557 is a reply to message #503543] Mon, 14 December 2009 12:06 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Jirong,

I am not sure what you are asking, but there is a concat aggregate
function to concatenate strings from multiple rows in BIRT.

Jason

Eric Rizzo wrote:
> Copying this to the BIRT forum (eclipse.birt for newsgroup readers).
>
> On 12/14/09 6:08 AM, Jirong Hu wrote:
>> Hi
>>
>> e.g. if a Defect has multiple attachments, when you create a query to
>> list all Defects with Attachment field, the query result will have
>> multiple entries for this Defect with different attachments.
>>
>> Now the customer want to have one entry only with all attachments in it.
>> I think we can do that in a report, but how to achieve in a BIRT report?
>>
>> Jirong
>
Previous Topic:parameter.displayText in RE
Next Topic:How to display HTML in a Table Column?
Goto Forum:
  


Current Time: Thu Mar 28 09:39:05 GMT 2024

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

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

Back to the top