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
- Connect to the universe on which you want to create a crosstab
- Select the dimension and expand it
- 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.
- Select the desired members of the hierarchy to include in the query by clicking on the drop down symbol
- Expand the hierarchy tree to understand the hierarchy structure
- Expand the sub hierarchies in the list and click on the button "Select All" (It includes all members of the hierarchy in the query)
- Click on OK
- Add additional objects to the query
- Check "generate Report" check box and click on finish
- Insert crosstab in the report header section
- Select "Row" and the "Total" and click on insert
- Click on page tab to view the report and the report will look like this
- The crosstab displays the results in a format that reflects the hierarchical structure of the data.
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