Question

I have a crystal report that uses a stored procedure. The data in the stored procedure is returned very fast. When I run the report for 6 months the report works just fine. When I run the report for a year it chokes on me.

Is the report just to big? What are some good methods to getting Crystal reports to display a years worth of data?

This report does a lot of time calculations on 88,000 records returned from the stored procedure for the year.