SAP Knowledge Base Article - Public

1386457 - Crystal Report with static prompts loads slowly

Symptom

Initial Load of Crystal Report, in Infoview, takes a long time to show the prompts, even though they are static

Cause

There are three optional settings that may be effecting the load of the initial prompts. It is possible that:

  1. There is a printer selected in Page Setup, that exists on the client machine, but does not exist on the sever
  2. The report option is set to "Verify On First Refresh"
  3. The report option is set to "Verify Stored Procedure on First Refresh"

Resolution

  1. Open Report in Crystal Reports Full Client
  2. Click File/Page Setup
  3. Click "No Printer" -- This will force the report, when run on the server, to be set automatically to the default printer, instead of looking for the printer driver that was set up on the client machine where the report was developed
  4. Click "OK"
  5. Click on File/Report Options
  6. Remove the check mark from "Verify On First Refresh" and "Verify Stored Procedures On First Refresh" -- This will force the report to skip the process of querying the database to verify metadata information
  7. Click "OK"

Keywords

stproc calls, too long, table validation, database calls, DB calls, parameter page , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2