Skip to Content
Former Member
Aug 17, 2011 at 11:11 AM

Wrapping Crosstab using SAP Hierarchy in Crystal Reports


Hi Experts,

hope you are fine!

Need some advice and helpful hints achieving my goal.

Frontend Tool: Crystal Reports for Enterprise SP2 or even Crystal Reports 2008.

DataSource is BEx Query with Profit Center Hier. in columns and a cost type structure in Rows.

Using a Cross Tab and selecting the PC in columns, results in that Crystal is displaying the hierarchy as it is, which is actually good.

But not readable if you have more than 150 child nodes and more than 15 Levels.

I am looking for a optimized way to display such a scenario.

Whtin this lesson the mentor is explaining how to wrap columns within crosstabs.

Link: []

The formula @EachRegion is counting the rows and the formula @GroupRegions is than defining the number of regions to be displayed in the columns.

I was looking to replace the formula @EachRegion with the HierarchyLevel(GroupingLevel) function which is delivering the same result, but due to any reason I can not group on this formula.

My intention was grouping on the level number and keep all nodes on the samel level together so the wrapping should happen level wise. The report finally should look like this using a cross tab:

Group 1 level 0

cost a 50

cost b 20

... ...

Group 2 level 1

cost a

cost b

.... ...

Or do you have other option to have a better view on this, maybe using subreports or anything what Crystal is offering?

Apologize if this sounds a bit confusing, but your hints are much appreciated.

Thanks and bye