Showing tree structure?

[HHalim]

Hello,
I've been using RadTreeView with great success in my project. And, now I need to show the underlaying tree view data structure in a report. I'm planning to use telerik Reporting to do this.

I'm new to telerik reporting, so my question is: Is it possible to show tree structure using the reporting tool? The database structure is similar to the tree.mdb from RadTreeView demo here: databinding radtreeview
It's a simple table with id and parent id columns.

And, if this is possible, where do I start? What parts of the reporting tool should I use?

Thanks!

[Svetoslav]

Hello hhalim,

To our great regret the current version of Telerik Reporting does not support recursive hierarchies out-of-the-box, which is exactly what you are asking for.
Up until now we have not found any possible solution that can work with the current version.

We have this feature already in our TODO list, and we will do our best to become available as soon as possible.

Thank you.

Greetings,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[HHalim]

Thanks for the reply.
Okay, if not out of the box component, is there a workaround for this? Such as:
1. With server code, get all the data tree structure.
2. Arrange the data internally on the server as a text, example:
Section 1
     Page 1
          subpage 1
          subpage 2
     Page 2
          subpage 2-1
etc....
3. Send the text tree structure from #2 to a reporting textbox?
Essentially that's all I need to do, no need for any advanced features.

Again, not having any experience with the reporting tool. Will that workaround work? Can the textbox dynamically expand itself if there is more text, or it must be fixed width?

[Svetoslav]

Hi hhalim,

Actually the recursive hierarchies can have random depth which from the Telerik Reporting point of view means random number of groups. In order to do this you have to count the depth first and then add as many groups (that group by parent id) as levels you have. Then arrange the items inside the group sections according to the group depth.

In case you have plain view of the tree structure you can create a suitable report layout using the Report designer and not bothering with any complicated calculations.

Having in mind the above information we encourage you to give it a try. We recommend as a start to take a look at the accompanying examples to get the idea how to use groups and if you have any furtherer questions do not hesitate to write as back.

Regarding the growing TextBox-es - the TextBox item can grow or shrink by height only - its width is aways fixed. To specify how the TextBox behaves when displays larger or smaller text one can use the TextBox.CanGrow and TextBox.CanShrink properties.

I hope this information helps. Thank you.

Best wishes,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[HHalim]

The tree structure I have has a fixed depth, 3 deep at the most. And, textbox fixed width is fine, the dynamic height is what I meant, sorry typed the wrong unit.

Thank you for the reply and detailed explanation, you guys are the best!!!

[James]

Has this issue ever been addressed? We currently are attempting to build a report for a hierarchy that has a random depth. 

 

Thanks,

James

[Stef]

Hi James,

The layout can be achieved with Telerik Reporting, but having into account the undetermined data, our recommendation is to use a control that can be later exported in other format.

The approach with Telerik Reporting is custom and it will require adjustments - Cross tab report with a self referencing hierarchy.

Other suggestions:

1. Telerik Document Processing Libraries
2. Kendo UI: TreeView / Binding to remote data

Regards,
Stef
Telerik by Progress