KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Having Perfect tree Structure with Pivot #1570

Open Anil Vithani opened this topic on on Aug 17, 2020 - 1 comments
Anil Vithani commented on Aug 17, 2020

Problem Statement :

We have teams organized in following was in database table: ID, PARENT_ID, TEAM_NAME

So there can be n levels using parent id, there is no fixed hierarchy with teams.

We have show report in pivot table like below

Team > team > team > Consultant

1) A team can be assigned to more than one Consultant, 2) A consultant will be assigned to only one Team. 3) A team can have many teams underneath

We have already got pivot working like Team -> Consultant

But it need to be Team -> Team -> Team.....-> Consultant

David Winterburn commented on Aug 18, 2020

Hi Anil,

Since your hierarchy is not static it's not a simple problem to build the row/column structure for Pivot. Please be patient while we try to find a solution for you. Thanks!

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed
Pivot

Designed and built with by KoolPHP Inc.

Code licensed MIT.