Symptom
- Dynamic Parameter Prompt with thousands of unique values takes a long time to load
- Same values load via a SQL Query or Crystal Report much more quickly
Environment
- Crystal Reports Designer XI R2
- Crystal Reports Designer 2008
- Crystal Reports Designer 2011
- Dynamic Parameter Prompt
Reproducing the Issue
- Create a new Crystal Report on a database with thousands of unique values
- Add a Dynamic Parameter to the report that prompts with thousands of unique values
- Add the parameter to the Record Selection or anywhere on the report
- Refresh the report
- Notice that the Parameter takes a long time to prompt
Cause
- The issue has been identified and logged under Problem Report ID ADAPT01507133
- Defect in the Prompt engine causes list of values to be processes inefficiently
Resolution
For Crystal Reports 2008 the issue has been fixed in the following Fix Packs:-
- Service Pack 3 Fix Pack 3.5
- Service Pack4 Fix Pack 4.1
- Service Pack 5
For Crystal Reports 2011 the issue has been fixed in the following Support Packs/Patches:-
- Support Pack 4
Above mentioned patches Contain a fix to the prompt engine that dramatically improves prompting performance the fix was for BusinessObjects Enterprise Scheduling and also fixes the CR Designer due to it being in the prompt engine
Keywords
- Crystal Reports
- Dynamic Parameter Prompt
- Slow Performance
- Long Time to Load
- Prompt engine
- LOV
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports XI