• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1023
  • Last Modified:

Slow Response of Crystal Report

Hi Experts

I am using crystal report 11 in my asp.net application. but Crystal Reports performance is terrible. Moving from page to page is terrible. can any expert tell me how to tune my crystal report performance.
its very urgent.

Thanks,
Ahmad
0
imrancs
Asked:
imrancs
  • 2
1 Solution
 
Jeff-NetCommented:

To speed up report processing in any Crystal Report, here are some quick tips:

1) Put as much memory as possible on the machine running reports. Crystal Reports LOVES memory.
2) If you are dealing with large databases, pull the data into the report using a stored procedure, as opposed to adding tables to your report and linking them there.
3) Subreport placement and whether or not it's on demand or not can make a difference, too.

If you want further explanations as to how and why this stuff matters, just let me know.

Jeff
0
 
imrancsAuthor Commented:
Hi Jeff-Net

In most of the reports i am using store procedure and views. how can i give more memory to crystal report. and i need more tips.

Thanks,
Ahmad
0
 
Jeff-NetCommented:

You give more memory to Crystal by adding more to the machine and having  a fast hard drive (for the memory swap).

Jeff
0
 
hongclubCommented:
i am using stored procedure too ... any my report is running slow ... and each time i use the toolbar it seems like re-run the report again.

Please advise,
Tommy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now