SAP Knowledge Base Article - Public

1551221 - How to get the new objects reflected in Crystal Reports when added in the Universe?

Symptom

  • Changes in the Universe does not get reflected in existing Crystal Reports
  • When new fileds are added in Universe, that is not visible in existing Crystal Reports

Environment

  • Crystal Reports XIR2
  • Crystal reports 2008

Reproducing the Issue

  1. Create a report (Report1) based on any (e.g. efashion) Universe.
  2. Open Universe Designer and import the required universe (File > Import ).
  3. To make changes in the universe, follow these steps
    1. Click on " Insert Object" (available in the above menu bar, blue colored parallelogram)
    2. Under "Edit Properties of Object" window, Write the name of the new object under "Name":
    3. Click on the arrow under "select".
    4. Select any table and click on "+" symbol to maximize that table under "Tables and Columns".
    5. Select a column whose datatype should be same as of the object datatype.
    6. Double click on that column.
    7. Click on "OK", again click on "OK" on next window.
    8. Save the Universe by clicking save button.
    9. Export the Universe(File > Export> OK)
  4. Open the already existing Crystal Report
  5. Now the newly added object in the Universe will not be available in the Field explorer of this existing Crystal report.

Cause

This is default behaviour of the Product where "Change to New Universe" option is not available under "Set Datasource Location" in Crystal Reports XIR2

Resolution

1. To reflect the changes made in the Universe in the existing Crystal Report(Report1), follow the steps given below:       

For Crystal Reports XIR2:

  1. Open the  existed Crystal report.
  2. Click on Database > set Datasource Location 
  3. In the second pane, under Universes, double click on "Make a new connection",select the Universe > click on "open".
  4. The new Objects appears in the Query Panel
  5. Drag all the required objects in the "Result Objects" along with the new object > Click on "OK".
  6. Click on the same universe again > "Update">  "Close".

For Crystal Reports 2008:

  1. Open the  existed Crystal report.
  2. Click on Database > set Datasource Location 
  3. In the second pane, under Universes, double click on "Change to New Universe",select the Universe > click on "open".
  4. The new Objects appears in the Query Panel
  5. Drag the new object under "Result Objects" > Click on "OK".
  6. Click on the same universe again > "Update">  "Close".

2. The new Objects added to the Universe will be visible in the field explorer of the existing report which can be used.

Note: "Change to New Universe" option is not available in CR XIR2 so we need to drag all the objects in the query panel while creating new connection, however since this option is available in CR 2008 we just need to drag the newly added objects in the query panel.

Keywords

Change, Universe, CR XIR2, CR 2008 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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