Line Chart Optional Y series Grouping problem

Hello, everybody
I have a big problem, I designed a line chart with optional y series grouping, the x series is snapshort time with interval of ten minutes, the Y series is the number of requests from each service group on the snapshort time. If I choose to render many days records, the resultset will be very large, about 30000 records. For each service group about 5000 records, if I choose optional y series grouping by each service group, the result chart will only render 3 service group's records, the other 3 are missing from the result chart. How can I do? (The chart only has three lines for the first three service groups and the others are missing)

Pleas help.

Find more posts tagged with

Comments

bhanley

Can you attach your report design to the thread so I can have a look?

zjliu

Thanks for your reply, bhanley,
Please see the attachment for detail, I select service group 701,702,703,704,705 and 706's records from the database, the grid below the chart displays the resultset, it contains the complete records. In the chart, I have the optinal Y series grouping by service group, the chart only displays the line for service group 701, 702 and 703, the other three service groups are missing from the chart. I think this is a problem of the class AutoScale and some related classes of birt. (my birt version is 2.3.1)
I really need your help, thanks for advance.

zjliu

This attachment is the report design file.

zjliu

I have resolved this problem, the reason is that birt set the ChartUtil.CHART_MAX_ROW value to 10000, it means the chart engine only supports 10000 records, but the records of the database is far more larger than the max value. So I changed the parameter to a larger value use the System.setProperty("CHART_MAX_ROW", 100000) method, it is a easy problem, but take me a long time to resovle it.

a3e

just curious

how/where did change or use the System.setProperty("CHART_MAX_ROW", 100000) method??

thanks

Virgil Dodson

For a Java application, you can set this on the command line as you start the JVM as described here: 
<a class='bbc_url' href='http://wiki.eclipse.org/BIRT/FAQ/Charts2.2#Charts_cannot_render_more_than_10.2C000_rows'>BIRT/FAQ/Charts2.2 - Eclipsepedia</a> 
 
... or within you Java class using System.setProperty 
 
... or within the Actuate BIRT Viewer setting BIRT_CHART_MAX_ROW in the web.xml as described here: 
<a class='bbc_url' href='http://www.birt-exchange.org/wiki/Configuration/'>Configuration - BIRT Wiki - BIRT Exchange</a>