[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1022
  • 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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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