7

I am working in a window project in asp.net4.0. I am using Visual Studio 2010. I have create an Invoice report in Crystal Report . Problem is that It takes1 minute to load every time. I have searched on google and also unchecked the option "Save Data in Report". But it does not effect report loading time.

So please help me. provide any idea or solution of my problem...

user1877866
  • 271
  • 1
  • 2
  • 8
  • How long does the underlying stored procedure/query take? How many pages does it render? Have you checked "No Printer (optimized for screen display)" under Page setup? – Adriaan Stander May 21 '13 at 05:29
  • I have checked in coding by putting Break Points. So I found that when i write following line then it takes 50 seconds to load report objReport.SetDataSource(dtInvoiceDetail); – user1877866 May 21 '13 at 05:31
  • How many rows are in the datatable? – Adriaan Stander May 21 '13 at 05:33
  • Actually I found that i have created a crystal report in my old machine that is working fine in that machine. in That machine that takes only 4-5 seconds but now i have changed My Machine and it takes 50 seconds. But When I have redesign new report in my new machine then it takes only 2-3 second to load. So I am searching that what is real solution for this problem. may be u can understand this scenario.. – user1877866 May 21 '13 at 05:36
  • Did you check the printer settings for the old report? – Adriaan Stander May 21 '13 at 05:39
  • yes i have set all setting of new report as equal to old reports. As I have said a report created on new machine takes 2-3 seconds and old report of old machine take 50 seconds. please look in to this issue... – user1877866 May 21 '13 at 05:43

5 Answers5

17

Hi I have found the solution to my Problem:

Open Crystal Report in Design Mode then Goes To Properties of Crystal Report

Crystal Report -> Design -> Page Set Up -> Check "No Printer" property.

and then My Report Take 2-3 seconds to load every time on my machine as well as in client machine.

kyorilys
  • 822
  • 13
  • 27
user1877866
  • 271
  • 1
  • 2
  • 8
  • Thanks, it help me. By default it saves current printer and when deployed it is searching for that printer which takes around 30 seconds after setting no printer it is working very fast. – Ali Adravi Oct 08 '13 at 12:30
  • Had this problem for a long time and thanks for this and it solved the issue. :) – ViFer Mar 02 '14 at 08:37
  • Crystal report loads the page setting according to selected printer preference. if we have applied any page settings in printer preference then it would be taken first for the report document. This process takes some times. – Shell May 07 '15 at 05:36
1

Open Crystal Report in Design Mode then Goes To Properties of Crystal Report

Crystal Report -> Design -> Page Set Up -> Check "No Printer" property.

and then My Report Take 2-3 seconds to load every time on my machine as well as in client machine.

I support for the above answer, really it shows a lot of difference. Thank you guys.

Mukesh Ram
  • 6,248
  • 4
  • 19
  • 37
charitha reddy
  • 11
  • 1
1

Goto Project > click (Winform)properties... > click Build and select platform target choose x86 and

Kashif Khan
  • 11
  • 1
0

When Loading home page or some page just run empty Crystel Report(only solution for initial start slow), I think that time take ready for some DLL files.

code examples

reports.ReportSource = null;
this.Close();

hope this will help you!

Gayan Chinthaka Dharmarathna
  • 391
  • 5
  • 21
-1

I have solution for this. (this works for me!)

  1. From the report > right click> page setup > uncheck "no printer" for optimization.
    1. If it is still slow, go to Start > Devices and Printers. Remove all the printers that are connected to the network. You won't need printers in developing crystal reports unless you want to print the report.
Juran
  • 177
  • 1
  • 8