>We're using Crystal to produce reports because Crystal made it more straight-forward to do the multi-line totals that we do and handle the variable number of groups that is determined by the user at run-time. However, we are finding it to be too slow for our liking. And the .RPT files we're creating range from .5 to 1.5 meg which makes loading it into memory less than a snap. Has anyone found anything with Crystal's power but runs faster? We're working on the speed issue, but we're also wondering if we shouldn't be using something else.
CR is slow when you use ODBC to access the data. Create a PRG that pulls all the needed data into one cursor, then COPY TO MyTable TYPE FOX2X. CR can then read this natively. It will also take advantage of Rushmore, adding more speed.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer