Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Non-trivial tree structure
Migrateduser
Hi!<br />
I'm a BIRT newbie trying to figure out whether BIRT would be a suitable tool for my needs. Basically I'm looking for a reporting engine for a financial application.<br />
<br />
Unfortunately I'm stuck trying to figure out a reasonable way of implementing the hierarchical structure common to many of the reports I'd like to implement.<br />
<br />
A good example of this kind of report is an ordinary Balance sheet:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
Liabilities & equity
Liabilities
Current liabilities
Accounts payable
... # ###.##
Total accounts payable # ###.##
Payroll liabilities
... # ###.##
Total payroll liabilities # ###.##
Other current liabilities
... # ###.##
Total other current liabilities # ###.##
Total current liabilities # ###.##
Long term liabilities
... # ###.##
Total long term liabilities # ###.##
Total liabilities # ###.##
Equity
... # ###.##
Total equity # ###.##
Total liabilities & equity # ###.##</pre>
<br />
I.e. there's a nested set of groups, each group with a header, a number of items, and a footer.<br />
Each footer has the calculated sum of the items within the group (including any subgroups).<br />
<br />
The structure is fixed, and in fact, I would very much prefer the report design to dictate the structure. However, the header and footer of groups without any values should not be displayed.<br />
<br />
I tried two approaches;<br />
1. A "static" design using a grid. In this case I haven't been able to figure out how to fetch the data items for each row. Also I have no idea how to make it hide "groups" without content.<br />
<br />
2. Using a table with nested groups. The major problem I have with this approach is that the groups have different depths, i.e. the data items are not all at the same level. Some reports even need to mix data items and groups at the same level.<br />
<br />
Are there any good examples of similiar designs out there?<br />
Any suggestions?<br />
<br />
Regards,<br />
Christer
Find more posts tagged with
Comments
There are no comments yet