1282812 - How to combine two fields from two different tables in an universe having a common field?

SAP Knowledge Base Article - Public

1282812 - How to combine two fields from two different tables in an universe having a common field?

Symptom

-To combine two fields from two different tables contained in an Universe having a field in common.

Reproducing the Issue

  • Create a report based on a Universe with two tables.
  • The tables must have a field in common.
  • Try to report on both of these tables
  • Crystal Reports XI R2
  • Oracle 9.2.1

Resolution

  • Create a report using the Universe.
  • Create two queries for building the report.
  • In the first Query take the first field to be shown in the report.
  • In the second Query, take the second field and the field which is common to both the tables.
  • In the Database Expert, go to the Link tab and change the link to "Left Outer Join".
  • Now in the report, you will have the desired fields showing all the data from both the tables.

 

 

 

       

Keywords

Combine tables based on Universe    Display records using a common field , KBA , BI , Business intelligence solutions , How To

Product

SAP Crystal Reports XI R2