BIRT Group BY Help

userjava

Hi,<br />
<br />
Can you help on this group by?<br />
<br />
I have data as<br />
<br />
Country ID | Country Name | Language ID | Language Name<br />
<br />
i want to group all Languages by Country ID and Sort by Country Name and show Country ID and Name (Only 1 time first record of multiple Languages)<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
1 | USA | 23 | English
| 24 | Spanish
| 25 | French

2 | India | 23 | English

</pre>
<br />
<br />
<br />
Can you help me?<br />
<br />
Thanks,<br />
User

Hans_vd

Hi,

If you create a table on your report and right click the detail row, you can choose Add Group. Also, you can select the table and go to the Groups tab in the property editor, and add a group. Automatically a header and footer row will be created.

The data you only want to see once, you put in the header row.
To get the header row data on the same line as the data in the detail row, you can use the table cell's drop property. Take a look at this post to learn about the drop property: http://enterprisesmartapps.wordpress.com/2011/12/13/birt-drop-group-header-property-and-table-border-lines/

Regards
Hans