Table and grouping.

Hello BIRT community, 
 
I habe a problem with Table and grouping. 
 
I have made my export to PRF with 3 tables. The first in the main table and then I have inner and inner/inner table. All are bound with grouping rules. My problem is that when many item should be displayed then it takes too much time. by 200 items 40 seconds. I think it calucates the tabels like loops so at the end I have something like n^3. 
 
I am trying now to do that with one table. How can I display groups on one level. I need something like this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

Title(Group1)

Nr(Group2) text(Group3) value time
value
text value
value
</pre>
where Nr and time are on the top level, then text in on the second and value is on the third level. 
 
For any hint, suggestion or examples thanks in advance.

Find more posts tagged with

Comments

kclark

I've attached an example report trying to create what you're needing, let me know if this is what you were wanting to do with the groups in the table.

Hans_vd

Hi Kosta,

You can use the drop property to display group data on the same level.
The first part of this blogpost describes exactly how to use the drop property: http://enterprisesmartapps.wordpress.com/2011/12/13/birt-drop-group-header-property-and-table-border-lines/

Regards
Hans

kosta

Thank you Kris and Hans for the answers.

I have solved it right now with group variables in the report design.
I have defined 2 counters. One that counts and the second as temp to see when the group count value is changed so the text is shown only first time in the group and any further texts are hidden (if the count and tempcount are equal visibility hide is true).
Only the detail row is visible and all groups are hidden at this approach.

I will test that "drop" attribute to see if it works. From your blog I can see the result and that is exactly what i need.

Modifing and attaching the file from Kris an example could look like this.

Hans_vd

Hi Kosta,

Good to see you have it working.
I've written a blogpost about your solution too I think :-)
http://enterprisesmartapps.wordpress.com/2011/12/26/birt-drop-group-header-property-with-doc-output-type/

Regards
Hans

kosta

Hello Hans,

yes, it was your blog. I meant that in my writing before. Only I used the example from Kris and changed like you 've described in your blog.

Thanks again guys.

kosta

double post <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif