SAP Knowledge Base Article - Public

1697165 - How to create a cross tab for hierarchical data in crystal report for enterprise

Symptom

How to create a cross tab for hierarchical data in crystal report for enterprise

 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

Crystal Report for Enterprise 4.0

Resolution

  1. Connect to the universe on which you want to create a crosstab
  2. Select the dimension and expand it
  3. Double click on the Hierarchy field

Note: In data sources containing hierarchies, hierarchy objects can be found at the top of the list of objects when you expand a dimension. We can identify it by distinctive icon.

  1. Select the desired members of the hierarchy to include in the query by clicking on the drop down symbol
  2. Expand the hierarchy tree to understand the hierarchy structure
  3. Expand the sub hierarchies in the list and click on the button "Select All" (It includes all members of the hierarchy in the query)
  4. Click on OK
  5. Add additional objects to the query
  6. Check "generate Report" check box and click on finish
  7. Insert crosstab in the report header section
  8. Select "Row" and the "Total" and click on insert
  9. Click on page tab to view the report and the report will look like this
  10. The crosstab displays the results in a format that reflects the hierarchical structure of the data.

 untitled.png

 

 

Keywords

Crosstab  based on Hierarchy data, crosstab in crystal reports 4.0,crosstab in 4.0,crystal reports Enterprise for 4.0, hierarchy data, Universe hierarchy data with crosstab , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , How To

Product

SAP Crystal Reports all versions