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
Data set with dynamic table name and unknown number of series in a chart
Migrateduser
<div style="margin:0px 5px 5px 0px;color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">
<p>I'm new to Birt, so I might be doing this the wrong way...</p>
<p>What I need to do is to display statistical data in reports. Data will be prepared overnight in some special tables (I wanted to use materialized views, but haven't been able to find it in Birt report designer when connecting through JDBC to my DB - so I'll be using tables instead).</p>
<p>The typical chart I need to draw is : - month on X-Axis - a value on Y Axis.</p>
<p>For the Y Axis, there will be multiple series... But I don't know how many. Each serie data will be fetched from one of those special report table I was talking just above.</p>
<p>I have two main problems : - how to display N series on a chart, N being unknown ? - how to dynamize table names in a data set ?</p>
<p>Is there a more Birt-ish way to do so ? Maybe I have it completely wrong from the beginning, really don't know.</p>
<p>Thank you for your help.</p>
<div>Mathieu</div>
</div>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet