QUESTION:
There seems to be a long delay in showing the Parameter Window when selecting a report from the list and selecting the 'View Report' button. That is... the time before the Parameter Window appears. What could be the problem?
ANSWER:
More than likely, it's one of these three things:
1) When a report is created, it's created and test on a specific printer name. Crystal REMEMBERS that printer name and any time the report is opened, it will first search for that printer. Crystal uses fonts and the printer it was designed for to render the fonts/layout of the report. On a large network, it will search a long time until it finds the printer. If it can't find the printer, it will eventually time-out and continue on. So, how do you fix this? Open the report and assign it a printer you KNOW exists on your network, so when it's opened, it finds it immediately.
2) Make sure you're not loading large RPT files with saved data, especially from network drives. When you save reports (RPT files) with saved data (File, Save Data with Report), Crystal Reports compresses the data into the RPT file. When you open the RPT file later it has to uncompress the data before allowing you access to run the report.
3) If your reports use a live data query to load parameters, this can take quite a bit of time, and it can vary greatly. There is a "LOV" registry setting (list of values) that can be tweaked to adjust query/wait times. It can be found in the registry at:
32-bit
HKLM\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
64-bit
HKLM\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
By default, we set MaxRowSets to 5000. Try adjusting this to 1000 and see if it makes a difference for you.
---
Let us know if this was helpful.
