Forum Discussion

kmpmuthu's avatar
kmpmuthu
Frequent Visitor
7 years ago
Solved

Hierarchy data display in slicer or table data

Hi,

We are using Hierarchy SQL table data in report and it should display like hierarchy format based on below condition.

How can I acheive this?

 

WHERE (company.Hierarchy.IsDescendantOf(('/700/'))=1)

 

I want to display Parent child data based on Hierarchy.IsDecendantOf()

1. Parent 1

1. Child 1

2. Child 2

3. Child 3

       1. Child 3-1

       2. Child 3-2

4. Child 4

Thanks in Advance.

 

Need Help
Show and Tell
Tips and Tricks