Deleting rows from a dataset

I have a report that has a column chart where the height of each column corresponds to the duration of an event. By sorting these columns largest to smallest, a visual distribution of event durations is produced. The duration of a specific event is not important, rather the contour of the resulting curve.

Occasionally, my customer gets an error on charts indicating that more than 10,000 records are bound to a chart. The report throws an exception and the chart does not render.

Is there a way to detect that a dataset row count exceeds 10,000, then delete every 2nd or every 3rd row from the dataset (whatever is necessary) to bring the total number of records below 10,000 to avoid the error?

Find more posts tagged with

Comments

mwilliams

Hi clearstone,<br />
<br />
Here's a post in the wiki that may help you out:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/wiki/BIRT:Charts2.2/#Charts_cannot_render_more_than_10.2C000_rows'>BIRT:Charts2.2 - BIRT Wiki - BIRT Exchange</a>

clearstone

Thanks for the reply.

Unfortunately, when presented with this solution, my customer was concerned with exhausting resources on the report server. Trying to create a report that works with many DB vendors also prevents incorporating procedural SQL.

Are is there a way to skip a row returned by the SQL query in the onFetch() method? I could return that total row count in the query and, based on the total row count, skip every other row or every row that is not a multiple of 3 or 4.

Regards,

CS