Charts not displayed in report

drishti

hello,

I have designed a report in BIRT 2.6.2

when i run this report on trial iserver on a DB with 10,000 records, reports run without any error.

But when the report is run with a DB of about 3 lakh records, charts are not displayed on the report.

Also it takes 6-7 minutes to run the report.

Please help.

Attaching the design report file.

rmurphy

From a quick review of the rptdesign, I see a few things:<br />
<br />
1. Don't do a select * in your data set. Only return the columns you will actually use in your report.<br />
2. Evaluate performance difference of separate specific queries versus one multi-purpose query. For example, for the pie chart, I would use a query that summed total calls grouped by queue_name and that would be the only two columns returned from the query. The data engine in BIRT is extremely fast, but databases are still the optimal choice for this when possible.<br />
3. Only bind data set columns to report items that will actually be used by the report item. The pie chart uses two column bindings, but has every column from the data set bound to it.<br />
4. You should really take a dimensional approach to designing your cube. To do this, you will have a query that produces your fact table, and queries for your dimensions. Then use linked groups to define the relationship between the dimensions and the fact.<br />
<br />
You should review the following webinar about designing high performance BIRT Reports:<br />
<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/977-webinar-archive-designing-high-performance-birt-reports/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/977-webinar-archive-designing-high-performance-birt-reports/</a&gt;