Dennis,
Duh. I should have mentioned this yesterday. Sub-reports are much like a multi-table form. If you have common columns between tables, nothing shows. So sub-reports need unique info with a linking column. Jan -----Original Message----- From: Dennis McGrath <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 22 Jun 2012 13:22:05 -0500 Subject: [RBASE-L] - RE: Tree Report I got the report working at least for the first 2 levels. The rest should be more of the same. I created 2 views --Start At root CREATE TEMP VIEW TempLevel1 + (TempID1,TempPID1,TempText1) + AS SELECT TempIDField, TempParentField, TempTextReturn + FROM TempProdCatBOMData WHERE TempParentField = -1 --join subReport to TempID1 CREATE TEMP VIEW TempLevel2 + (TempID1, TempID2, TempPID2, TempText2) AS SELECT + TempParentField, TempIDField,TempParentField,TempTextReturn + FROM TempProdCatBOMData The report runs off the first view. The first sub-report runs off the second view. The only link between the two views is TempID1 The other levels should be just more of the same technique using additional views with appropriately numbered columns. 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 Dennis McGrath Sent: Friday, June 22, 2012 8:45 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Tree Report 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 fil ls 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]] 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]
