Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 22nd, 2003, 01:55 AM
Authorized User
 
Join Date: Aug 2003
Location: jeddah, , Saudi Arabia.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default How do i improve the performance of report

I have statistical report developed in crystal report 9 which has all count and totals formulas which queries more than 15 millions of record and is taking more than 5 minutes to query and display the records.
How do i improve the performance of this report?
Any body has the solution

thanks

syedjavid
__________________
syedjavid
 
Old October 24th, 2003, 10:09 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

How are you storing your data? SQL Server?

What are you using for recordsource? SQL String? ADO?

Sal
 
Old October 25th, 2003, 02:01 AM
Authorized User
 
Join Date: Aug 2003
Location: jeddah, , Saudi Arabia.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes SQL SERVER 2000,
SQL string

syedjavid
 
Old October 25th, 2003, 01:49 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you are sending a string from Crystal report, create a stored procedure on the server and this will improve prformance, but only by about 20% or so.

Make sure that you are using your indexes in your database table.

How many joins are you using?
How many tables are you hitting?

Sal
 
Old October 26th, 2003, 05:46 AM
Authorized User
 
Join Date: Aug 2003
Location: jeddah, , Saudi Arabia.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks, i will try

syedjavid




Similar Threads
Thread Thread Starter Forum Replies Last Post
How to improve performance with VBA and Powerpoint ravan76 Excel VBA 0 June 10th, 2007 11:29 PM
how to improve this code? dhaval229 SQL Language 0 February 20th, 2006 04:38 AM
how to improve this code? dhaval229 SQL Language 0 February 20th, 2006 04:36 AM
How to Improve Myself in ASP ranuji BOOK: Access 2003 VBA Programmer's Reference 4 April 22nd, 2005 08:53 AM
Performance when loading report contains subreport jessicawkm Forum and Wrox.com Feedback 2 November 16th, 2004 10:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.