asked on

Is there any way to "chunk" the data in a crystal report?

I need to integrate a crystal report that will have about 1.3 million records into a VB6 PC application. In the current architecture, VB6 executes the query and passes the recorset to the report. With a recordset this size, the application is freezing up and or returning an overflow error. I'm wondering if there is anyway to "chunk" the data inside Crystal so the data is more manageable and avoid locking up the application. I don't want to force the user view the report in pieces - for example view the first 100k lines and then refresh it to see the next 100k.

I'm open to any suggestions.

Thanks in advance.

Kurt Reinhardt

Why does an end user need to see 1.3 million records in a report? It's doubtful anybody can interpret that data in a meaningful way. If you're simply returning a ton of records so that an end user can pick out exceptions, wouldn't it be easier to write a report that identifies the exceptions?

jdaingerfield

ASKER

rhinok - the short answer is no one would really want a 1.3 million line report. However, the application MUST allow users to run report WITHOUT any filter/selection criteria. If that happens, then the entire database is returned which is about 1.3 million records. And if the report fails with 1.3 million recs, then the client's QA department sends it back to us to fix.

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Is there any way to &quot;chunk&quot; the data in a crystal report?

Is there any way to "chunk" the data in a crystal report?