How to Identify Nodes in Hierarchy in CR Enterprise

[DebjitSingha]

Hi,

I am using Crystal Reports Enterprise 4.0 and connected to BEx query via BICS connection. My requirement is to show hierarchy as below:

                           Cost

AAA                       

     BBBBB                 1  

AAA Total -                1

all we can get is this-

AAA               4

     BBBBB          1

          CCCCC          1

               DDDDD          1

I need to make the parent node  and add Sub totals bold. Not sure how to identify parent nodes in Enterprise, as I know in CR2011 we get hierarchy node ID. Beside we would like to keep keyfigure columns allied as first example. 

Thanks,

Debjit

[jyothirmayee_s]

Hi,

Glad it worked out

Thanks,

Jothi

[DebjitSingha]

How can I display selected parameter text in the report layout? Only key is displayed, if I put parameter on the layout.

http://scn.sap.com/thread/3426479

[jyothirmayee_s]

HI,

You can try creating formula in Crystal:

Insert a group on Hierarchy  and create below formula, place it in group footer.

@Level

if(

hierarchylevel(Groupinglevel([Hierarchyname])) = 1 ) then

sum(Cost)

Format Group footer Hide (fx)

@Level = 0

Thanks,

Jothi

[DebjitSingha]

Hi Joti,

Problem is that once we include Hierarchy in a group. All nodes are appearing in one grouping header GH (Instead of Level 1 in GE1 level 2 in GE2....).

So if we use this formula the result will be same for all levels.

Thanks,

Debjit

[jyothirmayee_s]

Hi,

In CRE 4.0 Bex hierarchies do display as parent and node level.

I tried with one of my Bex hierarchy and it did showed up correctly with the above formula.

Where are you placing the hierarchy?. can you post a screen shot of Field explorer and structure pls?.

Thanks,

Jothi