Crystal Report is Slow in loading Data

Question

0.00/5 (No votes)

See more:

How can I increase the performance of Loading Data in Crystal Report in asp.net?
It takes a long time to load data.
At first time of loading it takes time (because of query it takes time to fetch Records).
When the next or preview is clicked (page navigation...) also it takes the same time.
When the data can be loaded in the Report
When the report is opened in Firefox it is faster.

Sample Code

DataTable reportTable = GetSource();

if (reportPath != "" && reportTable != null)
{
    reportDoc.Load(@reportPath);
    reportDoc.SetDataSource(reportTable);
    crv.ReportSource = reportDoc;
}

In the page load the function is called each time the Records are loaded.

If I use above code in (!IspostBack) the paging is not working in the report.

How can I avoid them loading each time?

Kindly give me the solution
:(

Posted 14-Sep-10 2:28am

gnanam_2009

Updated 14-Sep-10 2:54am

LittleYellowBird

v2

Add a Solution

2 solutions

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 · 2010-11-22T09:00:00

Solution 1

The Posted code is not enough at least you should have posted the particular procedure or event.

Check this Slow load in Crystal reports[^]

Posted 22-Nov-10 9:00am

thatraja

gnanam_2009 · Answer 2 · 2010-11-22T17:27:00

Friends,

I found the solutions for that problem.

I stored the Report Document in Session and

i assinged the report Document to the Report Source.

Now it is faster.

the code is like that

if(!IspostBack)
{
// Fetch the source and
// Store the Report Doc in Session
}
if(Session["ReportDoc"] != null)
{
//Assign the Report Document alone in the Crystal Report Source
}

Thanks!