Crystal Reports XI hangs when opening a report

T

10

7

I am trying to open a report in Crystal Report 11 Designer (product version 11.5.8.826), but it seems to freeze up. This report use to work fine, but today the client could not load the report.

I also tried to open the report on another developer's workstation, with the same result.

Has this happened to anyone else?

Toni answered 13/10, 2008 at 14:31 Comment(0)

M

7

In the page setup menu, you can check the No Printer checkbox and it will no longer have the delay of looking for a printer on the network. I find it often useful to start a report against the Microsoft XPS Document Writer Printer or something along those lines though.

Must answered 15/7, 2009 at 20:21 Comment(0)

C

6

We found the answer. We used a program called Wireshark (www.wireshark.org).

We closed down every app, and just ran the wireshark and tried to open the report in the crystal designer.

Then found that it was trying to access the printer spooler service on a box we used, but changed recently to another box. So just restarted the service on the old box, and all is good again

Ciao answered 14/10, 2008 at 7:10 Comment(2)

I am not quite sure what you mean? – Ciao 26/3, 2010 at 16:2

I too had this issued. Worked fine on the development environment, but not on the test servers. An 'ExportToPDF' report was searching for a local printer, causing it to hang indefinitely. – Spring 28/7, 2011 at 13:25

N

2

Are you sure all servers referenced in the report are still online? If you've changed database connections on the report, I've seen Crystal store a reference to the old one even when there are no active usages. If the old server is offline, Crystal still tries to connect to it when loading and will hang for a long time. We had a report that used to load in seconds start taking minutes right after an old test server was powered down. Powered it back up, it loaded instantly again, even though all the connections to it were seeming removed. We wound up totally rebuilding the report from scratch.

I found it using Sysinternals TDIMon, it showed connection attempts and timeouts coming from Crystal.

Nadiya answered 13/10, 2008 at 14:46 Comment(1)

Similar issue for legacy reports and old non existant servers. Work around is to make sure you have a connection to a current database. – Schuster 12/4, 2017 at 4:41

O

1

I've had similar issues open a report and the designer concurrently.

At the time, I didn't have Internet connectivity and the designer was trying (unsuccessfully) to load the web content that is included in the 'Start Page'. Eventually, the timeout was exceeded and the report loaded. I unchecked the 'Show online resources'.

Oratorio answered 9/11, 2009 at 2:3 Comment(0)

G

1

I ran into this problem also and tried several items listed here. Didn't work. Then I tried opening the file I wanted from within Crystal Reports using the folder icon. The reports opened immediately. But if I used windows explorer and went to the folder they were stored in and then tried to open the crystal report it would take 5 minutes to load (3 minutes to load the designer tab, then another 2 minutes to load the preview tab).

Gendarmerie answered 11/8, 2011 at 17:32 Comment(0)

H

0

try this "C# code":

ReportDocument rpDoc = new ReportDocument()
rpDoc.Load(Server.MapPath(@"reportname.rpt"));

hope it helps

Hungary answered 6/8, 2009 at 16:0 Comment(0)

M

0

I had the same problem on Crystal Reports 2008 (XII)! I tryed to stop the Windows printer spooling service while CR was freezed and got instantly an anwer freom CR (Printer not.. blah blah using default...blah)

After that, i removed the 'Printer-checkbox' in page setup (answer above). After that i had no problem loading this Report in CR Designer and also the C# ReportDocument.Load(string filePath) worked fine....

Medley answered 30/3, 2010 at 13:44 Comment(0)

C

0

Crystal Reports are hanging from all windows servers 2008 R2 and IIS 7.5

Solution: Selected the printer 'Microsoft XPS Document Writer'. To do this go to the report in the designer->Design->Page-Setup and select.

Centurial answered 3/2, 2015 at 7:1 Comment(0)

V

0

We had this issue as well and determined that it had to do with the default printer that is attached to the printer when the report is created. Very similar issue and resoltuon to what Pirmin Ruegg encountered. Setting the default printer to one that all users have, or Selecting the No printer option, corrected our issue.

Victualler answered 18/8, 2016 at 13:38 Comment(0)

C

0

Same is the case with me. My application stucks when i view the report but after checking the "NO PRINTER" option in the crystal report designer it works fine.

Chibouk answered 19/1, 2018 at 10:6 Comment(0)

Recommended topics

Hot tags