franklin1232
IS-IT--Management
I am having trouble with a large report and it's run time. It takes almost 2 hours to format 45 pages.
First I verified the SQL server 2000 database configuration. The main report and sub report both use views for data. So I ran both at the same time and used that trace data to fine tune my indexes. Combined with out any filter parameters both views take less than 10 minutes to return data to Query analyzer when run simultaneously.
So I believe the issue is that the report has many formulas and running totals. I believe these are the problem since the first report page will load in about 10 minutes but to move to the next page I have to wait 10 more minutes and the next page is the same thing. Once the first page has completed is the database a factor anymore hasn't crystal already retrieved all the data? Any thoughts on troubleshooting the report field and the perfomace would be appreciated.
Thanks
First I verified the SQL server 2000 database configuration. The main report and sub report both use views for data. So I ran both at the same time and used that trace data to fine tune my indexes. Combined with out any filter parameters both views take less than 10 minutes to return data to Query analyzer when run simultaneously.
So I believe the issue is that the report has many formulas and running totals. I believe these are the problem since the first report page will load in about 10 minutes but to move to the next page I have to wait 10 more minutes and the next page is the same thing. Once the first page has completed is the database a factor anymore hasn't crystal already retrieved all the data? Any thoughts on troubleshooting the report field and the perfomace would be appreciated.
Thanks