crystal report taking too much of time to view report.

[sarojaramkumar]

Dear All,

Dear Team,
It is very urgent, your immediate attention is highly helpful and thankful

Environment used: WINDOWS 2008 R2 SERVER, CRYSTAL REPORT XI sp4, SQL SERVER 2008R2


I am customizing OE INVOICE report, when i try to open crystal report using report viewer - it is taking toooooo much of time to open
say more than 7 minutes..

Please help, here below is my coding. Please advise....

Thanks
SaroRam

 

[kray4660]

There are a great number of possibilities that could cause a report to be slow to open. 1. A large dataset 2. Not using a command or stored procedure (if possible) for the data source 3. Not enough memory. 4. Other processes running at the same time. Then there could be other things I have not thought of.

 

[hilfy]

5. You should upgrade Crystal to the last service pack that was made available for XI. See here:

https://blogs.sap.com/2011/06/07/where-did-all-the-crystal-reports-xi-r1-and-r2-fixes-go/

6. The report was saved with a large amount of data, making the file large. For this, turn off "Save data with report" on the File menu.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com