Crystal Report Viewer very slow

Question

0.00/5 (No votes)

See more:

My Crystal Reports take forever to load in my application - at least 2 minutes: This is my code. What do I do wrong?

private void button1p_Click(object sender, RoutedEventArgs e)
        {
            Windows.CrystalReportViewerWindow wnd = new ePAM.Windows.CrystalReportViewerWindow();

            // Change 'OperationalUnitTableAdapter' to appropriate adapter.
            ePAM.Reports.StrategyDataSetTableAdapters.OperationalUnitTableAdapter adapter = new ePAM.Reports.StrategyDataSetTableAdapters.OperationalUnitTableAdapter();
            adapter.Connection.ConnectionString = BusinessLayer.BusinessLayer.GetConnectionString();
            adapter.Fill(dataSet.OperationalUnit);

            // Change 'Operational_Units' to appropriate report.
            Reports.Print.Operational_Units objReport = new Reports.Print.Operational_Units();

            // Change 'dataSet.OperationalUnit' to 'dataSet.***'.
            objReport.SetDataSource(dataSet);

            wnd.MyReportViewer.ReportSource = objReport;
            wnd.MyReportViewer.RefreshReport();
            wnd.ShowDialog();

        }

Thanks in Advance

Suzie

Posted 12-Apr-10 22:57pm

Suziem

Updated 15-Apr-16 6:50am

Tom Deketelaere

v2

Add a Solution

6 solutions

Solution 6

basically when you run first time it always slow because opening and loading database is slow. from second time onwards it will become faster. to check create a empty crystal report and run it. you will see it is faster than the database connected crystal report.

Posted 6-Dec-11 18:10pm

Arthesh G

Solution 3

objReport.SetDataSource(dataSet);

Posted 13-Apr-10 0:10am

Suziem

Solution 8

CrystalReportViewer1.Refresh()

in this line it will take more time....

Posted 28-Sep-12 3:32am

isai gnanam

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)

Tom Deketelaere · Accepted Answer · 2010-04-13T00:16:00

Solution 5

Basically you just create a empty report and open it (no need to set data source or anything you just initiate it)
This will load the crystal reports framework into memory and should cut down loading time drastically.

Posted 13-Apr-10 0:16am

Tom Deketelaere

Comments

alrajhi20 11-May-14 0:15am

Would you please send the proper code for initiating it?

Tom Deketelaere · Accepted Answer · 2010-04-12T23:49:00

Check if the second time you open a crystal report is still loading as slow.

Crystal reports is very very slow on the loading for the first time but should be fast when loading the report (or a different one) for a second time (without closing the application)

If it's the case that it is only for the first time then I suggest that you load a dummy report (in the background on a different thread) when loading your application, without showing the report of course.

#realJSOP · Accepted Answer · 2010-04-12T23:49:00

Solution 2

Have you run this under the debugger to see exactly what part of it is slow? Which line is taking the most time?

Posted 12-Apr-10 23:49pm

#realJSOP