Re: How to aggregate a string field? [message #503543] |
Mon, 14 December 2009 16:16 |
Eric Rizzo 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 |
|
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
>
|
|
|
Powered by
FUDForum. Page generated in 0.03314 seconds