1574483 - Performance issues of Crystal Reports 2008 having more than 1500 distinct records in the List of Values.

SAP Knowledge Base Article - Public

1574483 - Performance issues of Crystal Reports 2008 having more than 1500 distinct records in the List of Values.

Symptom

  • The parameter dialog box takes the following time to display when the report is refreshed in Crystal Reports designer:
    -1500 Distinct LOVs = 16secs
    -500 Distinct LOVs <= 1 Sec
  • Performance issue occurs when a list of  more than 1500 distinct records is used in the LOV.

Environment

Crystal Reports 2008

Reproducing the Issue

  1. Note that HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal
    Reports\DatabaseOptions\LOV\MaxRowsetRecords 15000 is set on the BO Server.
  2. Open Microsoft Excel and create columns with 2000 distinct records.
  3. Launch Business View Manager.
  4. Click on File > New > Data Foundation and add this table.
  5. Click on Save to save the Data Foundation.
  6. Click on File > New > Business Element and add the created data foundation to the business element.
  7. Click on Save to save the Business Element.
  8. Click on File > New > Business View and add the created business element to the business view.
  9. Click on Save to save the Business View.
  10. Click on File > New > List of Values and add this business view to the LOV.
  11. Click on Save to save the List of Values.
  12. Right click on the LOV and click on Schedule the LOV.
  13. Launch Crystal Reports designer and create a blank report.
  14. Create new parameter by selecting Parameter in Fields Explorer and click on New.
  15. In the create new parameter dialog box select Dynamic in the List Of Values.
  16. In choose a data source option select Existing and choose the created LOV.
  17. Click on OK.
  18. Drop the parameter in the report header.
  19. Preview the Crystal Report.

Cause

The issue has been identified as a defect and is currently escalated to Product Group under ADAPT01533128.

Resolution

This issue has been fixed in Fix Pack 3.5.

Please upgrade Crystal Reports and Business Objects Enterprise 3.1 to Fix pack 3.5.

Keywords

Crystal Reports, large List of Values. , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1