crystal report taking more time to display..

Question

0.00/5 (No votes)

See more:

hi friends,

I am using crystal reports to display large amount of data i.e month wise or year wise.
Now, one of my report taking lots of time around(10 min - 12 mins) to display..
Is there any ways that i can use to optimize its performance.

thank you.

Posted 24-Sep-12 1:08am

Vikas_Shukla_89

Add a Solution

Comments

Vedangi 26-Sep-12 6:54am

You can make changes in Query or Stored Procedure to optimize performance

IpsitaMishra 31-Oct-13 8:25am

You can optimize the query so that it will be faster

Vikas_Shukla_89 27-Sep-12 6:50am

Thank you Vedangi,
i hav done everything to optimize the sql-query performance..
but the thing is, it retrieve more than 3000 records frm database, after this i m updating its qty from other table (for matching records).
Of course, it will take time to excute.
Now for first time, if it take this much time(10-12 min) then its ok but when user wnats to go to second page and clicks on next button then also it is taking 10-12 mins.
it is very tedious. Help me

Vedangi 28-Sep-12 3:37am

Have tried to use Index or Temp Table?

Vikas_Shukla_89 29-Sep-12 1:07am

yeah! i am keeping all the records in Temp table, and used CURSOR to update other columns like qty.

Neeraj Kumar Singhal 28-Feb-13 4:46am

i am using crystal report, first time it will take 30 to 40 second, how can i optimize perofrmance

Vikas_Shukla_89 5-Mar-13 2:19am

provide some code..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-10-31T02:14:00

Here some suggestions regarding the performance on both sides

Database side
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]

Crystal reports side
Report Analyzer: Optimize Crystal Reports[^]
Optimizing Report Performance[^]
Optimizing Crystal Reports[^]
Crystal Reports Slow Load Using .NET C# ( SetDataSource )[^]

Hope these will help you.