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.