Table and grouping.
Options
Hello BIRT community,<br />
<br />
I habe a problem with Table and grouping.<br />
<br />
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. <br />
<br />
I am trying now to do that with one table. How can I display groups on one level. I need something like this:<br />
<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.<br />
<br />
For any hint, suggestion or examples thanks in advance.
<br />
I habe a problem with Table and grouping.<br />
<br />
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. <br />
<br />
I am trying now to do that with one table. How can I display groups on one level. I need something like this:<br />
<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.<br />
<br />
For any hint, suggestion or examples thanks in advance.
Warning
No formatter is installed for the format ipb
0
Comments
-
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
HansWarning No formatter is installed for the format ipb0 -
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.Warning No formatter is installed for the format ipb0 -
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
HansWarning No formatter is installed for the format ipb0 -
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.gifWarning No formatter is installed for the format ipb0
Categories
- All Categories
- 109 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management