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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
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?
jdaingerfieldAuthor Commented:
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.

There probably isn't much you can do through Crystal.

Crystal cannot as you put it chnunk through the records.

You may need to change some settings on your server to provide a larger buffer or increase timeouts.

I also ask why you need the ability to see that many records.  If the user doesn't run with a filter then the report even if it ran fully would be relatively useless unless it was a summary tyoe report that showed only the summaries say of clients and their balances without showing all the transactions for the past 5 years.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.