SAP Knowledge Base Article - Public

1574566 - Dynamic List of value not getting updated after adding new Records in the Database


Dynamic Parameter shows old List of Values even after adding new Records in the Database


  • Business Objects 3.1
  • Crystal Reports 2008

Reproducing the Issue

  1. Create a sample Crystal Report named "Test_LOV" using "Customer" table in "Xtreme" sample Database
  2. In Crystal Reports Designer Launch "Field Explorer"
  3. Create a Dynamic Parameter on "Customer.Customer ID" field
  4. Publish the Report on Business Objects Enterprise.This will create the LOV Structure in Business View Manager
  5. Now open the "Xtreme" sample Database in MS Access
  6. Open "Customer" table and add a new Record with "Customer ID" = *123
  7. Save the table and close MS Access
  8. Refresh Crystal Report "Test_LOV"  in Designer or in InfoView
  9. The Parameter on "Customer.Customer ID" will show old LOV with new record Customer ID = *123 missing


The Data Connection preserves the structure of LOV and any Database changes are not reflected at "Data Foundation level". This can be tested by browsing the "Customer.Custpmer ID" field in the "Data Foundation". After making the changes in Database, browse the "Customer.Custpmer ID" in "Data Foundation". The new records would not reflect


  1. Launch Business View Manager and create a new connection "Connection_new" pointing to "Xtreme" Sample database
  2. Save the connection in any folder in Repository
  3. Open the Data foundation of old LOV and browse to the "Customer" table in left side panel
  4. Right click on "Customer" table and choose "Set Table Location"
  5. This will launch "Set Table Location" window with Add Connection option on top
  6. Select "Add Connection" and Browse to "Connection_new" and click on "Set"
  7. Click on "OK"
  8. Launch Crystal Report "Test_LOV" and refresh the report
  9. Now the List of Value would include *123


Business View Manager, LOV not updating,List of Value,Crystal Reports,Browse Data in Data foundation , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


SAP Crystal Server XI