Hierachy Filter in Paginated report's using PATHCONTANIS and PATHLENGHT

[kapil512]

HI,

I have a Paginated report's which we need to filter the data based on "CostCenter Hierachy" in multiple level's.

THis Hierachy already created in AAS model, i just want to filter the muliple level's and pass those parameters to final dataset.

I tried below solution it's not working as expected, below solution works in only one level, if i select Level 1 and Level 2, it's not showing any result.

[v-yangliu-msft]

Hi  @kapil512 ,

This is the related document, you can view this content:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/create-a-recursive-hierarchy-g...

https://www.alphabold.com/hierarchical-cascading-parameters-in-paginated-reports/

PATHCONTAINS

PATHLENGTH

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.