Aside from our larger reports (that’s chock full of data with many table links) taking minutes to run, waiting “minutes” for each page to print is a nightmare. The users are bypassing the site and having me run their reports direct out of Crystal. If the report takes a solid minute or so to compile and render a report, that’s fine and understandable but this shouldn’t be the case for each page it sends to the printer.
SQL Server 2008 R2 Sever 64 bit
Workstations Win7 32 bit
Crystal Reports 2008 (Report Development)
***VS2010 – VB.net .net framework 4.0
***Crystal Reports Viewer 13.0 runtime
To get a quick (or any) response, create your new discussion in a space related to your query. This way it will be visible to topic experts who will then see and reply to it. The SCN Site Index contains a full listing of all SCN spaces.
Moved your post to the SDK forum since this is Cr for VS 2010 question and not a Report Design question.
What Service Pack are you using? Have you tried SP 4.
Windows or WEB app? If WEB only upgrade to SP 3, viewer issues with header text formatting in SP 4.
Make sure you have ALL verify Database options checked off, only should be used when designing the reports. CR assumes the DB info and structure is as is when the report is finalized and Verify does not need to be called.
There were issues with the original release of CR for VS 2010 and it searching the local Domain(s) for the printer it was developed against, that was fixed in SP 1 or 2.
What type of data are you using, Hitting the DB directly or a data set?
When you refer to service packs, what product are you referencing?
Crystal Reports 2008 (Report Development)
This is a web app.
The database is being hit directly via CR selection criteria
under CR2008 development.
I will verify vs2010 service pack but I installed service pack 2.
Thanks for your support.
Hoping you can follow up.
Sorry, yes CR for VS 2010 is up to SP 4 now but there is an issue with the CR WEB viewer so get to SP 3 at least..
So now we need to know if you are using RAS or the engine and PrintToPrinter or PrintOutPutController to do the printing?
Client side printing or Server Side?
Are you breaking the report up to print a page range or the whole report at once?
Not clear on the info what you are doing and the configuration.
Also need to know are you setting No Printer in the Report?
Are the reports designed off the same printer that everyone else has access to?
Are you changing printers at runtime?
What Printer are you using and have you updated the drivers lately?
Lazer, Dot Matrix, Label Printer....?
I am depending on the engine.
I assume by engine you mean CR 13 runtime.
The reports uses CR 2008 filtering as opposed to the database engine as used
when stored procedures have been implemented.
I am using ASP .Net 4.0 in the app.
There is no code implemented for printing ie PrintToPrinter or PrintOutPutController.
The printing is server side as directed and selected using the domain controller.
This being the case, exactly what happens when the print event is fired via the
Where is this method/function in code?
Are there any suggested modifications in this area?
The reports can be point in time as opposed to realtime.
I did some research along with the programmer that develops the CR 2008 which
are rendered into the app using vs2010 and CR 13.
DBVerify is off
Printing is set to no printer
I installed sp3 for vs 2010.
- Rendering - 1 to 1.4 minutes (this is also the case when next page is selected)
- Loading Report To Print - 5 to 10 plus minutes before window to select printer
- Printing - 2 pages per minutes average 50 pages total 25 minutes once
printer section is made
- In some cases the report printed 7 -15 pages and restarted from the
beginning without any request to do so as if control was lost.
The test was not a stress test but a test executed with me as the only user.
Unfornuately, the users are still upset and they are going directly to the CR
programmer to have him print the report from CR 2008 directly.
Are there any tweaks to be made to the domain controller relative to printing?
All request are spooled.
All report request are made to print the full reports.
I tried printing to many different printers as well as local printing with the same
I would like you to see for yourself if at all possible and I have recieved permission
for you to do so using the following URL:
...Logon to test app info removed...
Thanks again for your support.
Wow.. that is slow...
So is this a test system or your DEV or Production server? I'll removed your logon info...
Do you have any logging enabled? That would explain the delay, you could have crlogger creating DB logs or crpe logging creating API logs or you may have IIS logging everything.
What happens if you create a simple app that calls the same report with everything preset?
Just a one liner: load report and preview, and use a report with saved data so it doesn't have to hit the DB.
I assume in the report designer when you hit the next page it instant?
I've implemented your suggestions
and the report production time has decreased
Before closing this issue another problem
has reared it's ugly head:
It looks to be replicating itself and is causing high memory usage
and the need to stop and start the service frequently.
I've read everything from w3wp.exe being a worm to reference to deleting
Can you point me in any particular direction based on my environment? This is my latest hurdle.
Thanks so much for your time and effort.
First, the saved data report was only a test, now add code to set log on info to see if it's the database causing the delay, then if that works then start adding the conponents in your main app to the test app. Be sure to check off the Saved Data with the report or hit the refresh button to refresh the data...
As for the w3wp.exe that is IIS, your web server. I have no idea what is happening with it so you may want to contact Microsoft or post to their forums. As for multiple instances that all depends on how you have configured IIS, if you have multiple AppPools running then each pool will spawn a separate instance of the w3wp.exe process. If you only have one AppPool then you may have either some configuring to do or you may have a virus... Microsoft is the best place to contact for these questions.