concat rows within a group?

Arif shah

<p>Hi,</p>
<p> </p>
<p>Does Birt have a functionality of concatenating multiple rows within a group? I am looking for something similar to the following mysql syntax</p>
<p> </p>
<p>Also, I want to know which one would be more efficient in performance?</p>
<pre class="_prettyXprint">
SELECT person_id, GROUP_CONCAT(hobbies SEPARATOR ', ')
FROM peoples_hobbies GROUP BY person_id</pre>
<p>Regards</p>
<p>Arif</p>

BRM

<p>This functionality exists for aggregation elements.  Add one to the group and select from the list of aggregation functions.  I am not sure which one would be faster.</p>