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
Nested grouping with multiple datasets
Migrateduser
<p>Hi experts,</p><p> </p><p>I have next to none experience what comes to BIRT reports. I'm trying to create a multilevel report to list item structures.</p><p> </p><p>Few questions:</p><p>I wrote sql query where each structure level are combined as one result set using UNION.</p><p>Totally 9 different queries. One for the item and 8 for the structure. Each query returns PARENT_CODE and STR_CODE. These can used for the joins.</p><p> </p><p> </p><p>What is the best way to accomplish this?</p><p>Should I split the query to multiple datasets?</p><p>How to join the datasets together so that STR_CODE is linked to PARENT_CODE?</p><p>If I do the datasets can I add some code that prevents executing all the structure queries if upper structure returns no value. These are quite heavy queries so in order to have good performace this would be great.</p><p> </p><p>Please see attached as an example of wanted output. Is it possible to hide columns if no data exists?</p><p> </p><p> </p><p>Example report would be appreciated.</p><p> </p><p>I'm using birt-rcp-report-designer-4_2_2</p><p> </p><p>Br,</p><p>Tupe</p><p> </p>
Find more posts tagged with
Comments
There are no comments yet