Our Crystal reports are running into performance issues, and we've been advised to disable/remove unnecessary configured printers associated with the report. Supposedly, loading the print settings can slow down the loading of a report, particularly when there are remote printers configured.
My question is, how do I disable certain configured printers for an individual report? I know of the "No Printer" checkbox in the Page Setup, but I'm guessing that isn't what is being referred to. Any ideas?
The issue where CR was searching for the printers across all of your Domains was resolved in Service Pack 2 I believe, so if you are not on SP 2 then upgrade to SP 5.
Likely the issue is in your Reports you have some or all of the Verify Database options checked on, they are on by default and should only be used when designing the reports. Before publishing/using in production, check all of the Verify options off.
CR is trying to connect to the original data sources, typically there is a 1 minute timeout by the DB client if the connection fails.
I don't recommend using the No Printer Option, CR defaults the margins and other parts to your default printers settings, better to design the reports against specific and supported printers than no printer at all.
Aren't those options only going to apply when any report is run within Crystal itself? The performance issues are occurring in Crystal Reports viewer in a third party piece of software (the third party made the suggestion of removing printer configurations). Are the database options associated with a specific report, or is it a general setting that affects any report in the Crystal environment?
Maybe what you should do is post what your results are how you determined performance is a Crystal Reports issue?
Where are you seeing the performance hits? Opening, initial refresh of the report, or when refreshing the report, saving to disk....
It may be your performance issues are not CR related, could be network or DB server performance or simply not enough hard drive space and Windows Swap file is where the delay is...
Please give details so we can stop guessing where the problem is and give you valid things to try/test/compare or to post to some other Forum for your Hardware and software. Could even be your AV software is scanning all data going your network card....
I'm not asking anyone to guess what the problem is. I'm merely looking for clarification regarding the database settings. It sounds like no one here is aware of any report-specific printer settings in Crystal other than the "No Printer" checkbox, but someone suggested that database settings could be a problem ("Verify on first refresh" and "Automatic Smart Linking"). I'm just wondering if those database settings are report-specific such that performance could be affected when that specific report is generated in third-party software.
I'm only responsible for the report file itself. If the problem is network/server related, it isn't my responsibility.