Thanks Tony, I've been there, done that. I was hoping to the sub-reports to do it in a more elegant way.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Friday, June 22, 2012 2:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Tree Report Dennis, A long time ago I have solved a similar problem. The subject was an organizational structure, which of course is hierarchical What I have done is the following: Define a text column of X length Then develop a routine which fills this field with a sort key Be sure this procedure is executed at the right moment Then you are able to create a report - without subreports The nice thing is that you are even able to make a selection from one particular node downwards. In my example I was able to select a department and its sub departments and so on If you like to have some code please let me know I will sent it privately. Tony From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Dennis McGrath Sent: donderdag 21 juni 2012 23:56 To: RBASE-L Mailing List Subject: [RBASE-L] - Tree Report I have a table TreeList (ID INT, ParentID INT, TextField TEXT (80)) The data shows nicely in a DBTree control. I'd Like to have a report print the same data in the same arrangement as shown on the DBTree. Has anyone done something like this? I thought it would be easy using a view for each level driven off a variable for the appropriate parent. My thinking was I could drive sub-reports off the views. I get the first level fine but cannot get the sub-reports to work. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]>
