prepare a report of 500 pages

[meensi]

Hi All,

I'm generating a report with Oracle Queries in CFQUERIES and using CFOUTPUT and Fusioncharts, preparing a report which will generate minimum of 10 pages to maximum of 600 pages.

At some times, I get an error "Null Pointer Exception" in the middle of execution.

Any tips on how to avoid this error?

Is there a better way or to speed up the performance when it generated more than 500 pages?

Thanks in advance!