Printing extremly slow

[Former Member]

Hey,

we are using Crystal Reports 2011 with .NET 4.0 on a Windows 2008 R2 64-Bit terminalserver.

The printing is very slow. Printing each document counts 5 - 10 minutes. The informix database is very fast (normal queries are fast).

I have enabled the logging and found out the block where the wait time begins:

|a8235f38-a552-f7d4-b881-915225a00c6c|2011 12 20 08:56:43:678|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1||||||||||||..\..\src\print\datasource\datanode.cpp:695,DataSet checking for datasource changes,Starting to check current datasource for changes,""

|857453c6-3d61-1c44-c801-c4d1048186bd|2011 12 20 08:56:43:678|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1||||||||||||N/A:-1,DataSet checking for datasource changes,Elapsed Time,"0"

|04b5ca97-ee4b-03f4-4a9a-331c8fc024a3|2011 12 20 08:56:43:678|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1||||||||||||N/A:-1,Checking for data source changes,Elapsed Time,"1"

|9c0de6ee-fd0f-2034-7bc4-457c848236b6|2011 12 20 09:02:08:366|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1||||||||||||..\..\src\print\datasource\dsmgr.cpp:3347,Checking for data source changes,Start Time,"09:02:08"

|2bc4406c-ec0b-ee84-d863-d0525143b2b0|2011 12 20 09:02:08:366|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1||||||||||||..\..\src\print\datasource\datanode.cpp:573,DataSet checking for datasource changes,Start Time,"09:02:08"

What is crystal reports doing at this point?? What could be the reason for this long delay while generating the report?

[former_member188030 · Accepted solution]

Hi,

I am assuming that you have designed your report with CR 2011 and you have deployed the application using CR for VS 2010 (13.0) runtiimes as CR 2011 does not have any .NET SDK.

Steps You could try -

- Use [CR for VS 2010 SP2|http://www.sdn.sap.com/irj/sdn/crystal-xcelsius-support?rid=/webcontent/uuid/d01fdad8-44e5-2d10-61ad-9d2d4158f3a8] runtimes

- Migratiing the reports to CR for VS 2010 would be helpful.

- Upgrade the printer driver.

Hope this helps,

Bhushan.

[Former Member · Accepted solution]

We exactly use this runtime (13.0.0.2). When I refresh a loaded report, the refresh takes only a few seconds. I started a single support call but no reaction yet..