I need a series of reports that display folder information in a hierarchical layout (undeterminate number of folder level parents/children) so i need to find a way to create a report that presents each level and then its children recursively, such as a recursive BandedReport or possibly a Subreport would do...
- Data is retrieved from an SQL database table in a self-referencing datatable(the Folder.ParentID points to another folder record with the same Folder.FolderID.
- I design the Reports in the StandAlone designer.
- We need them to be "self-processing"... that is, apart from setting parameters being passed from the calling Winforms Application, there should be no "additional processing" or "value setting" or "business logic" from the calling application. We need it to be truly "set parameters and call RefreshReport()" and let it go... This is so that we (AND our clients) can add reports like these to our application without needing to change application code or needing custom programming.
I have looked at and run the project from 2013 "Recursive HierarchyReporting" (https://www.telerik.com/forums/recursive-hierarchy-reporting) and found it somewhat useful except 1) it processes the selection of the subreports within the code class and 2) it uses a dataobject hierarchical layout within the data structure rather than a flat table of records that self reference.
can you point me to some more recent examples of how to accomplish the hierarchical report from a self referencing SQL datatable query?