Hi,
I will be building a report using the Automation Server to be run from within VB. I will need to report the contents of a tree, such as a directory structure. The tree can have any number of levels, and any number of children per node. I am looking for ideas on how to approach this in Crystal.
I have some sample code for saving and loading a tree to a file. I believe it could be modified to traverse the tree and build a linear recordset that I can feed to Crystal.
One idea I've contemplated is to create grouping on the fly, one nested group for each level in the tree. Some potential problems with this are performance, and running up against some upper limit as to the number of groups. I don't know if there is one, and if so, what it is. Also there is a finite width to the page, so indenting groups can only go so far and still have a usable output.
One advantage of this method is it would make use of Crystal's drill-down functionallity to see whatever level of detail the user wants.
Does anyone have any ideas about whether this would be practical, or any other approaches that might work? I could use the Report Designer Component if it has some control that would be useful. I've never used it so there would be a learning curve, and it would deviate from the architecture that is already in place with other reports built for this application. I'd rather avoid that if possible.
Is there any mechanism to include Active-X controls within a Crystal Report, such as in a subreport? If so, then I could use the same tree control that the application uses to allow manipulation of the data.
Scott
I will be building a report using the Automation Server to be run from within VB. I will need to report the contents of a tree, such as a directory structure. The tree can have any number of levels, and any number of children per node. I am looking for ideas on how to approach this in Crystal.
I have some sample code for saving and loading a tree to a file. I believe it could be modified to traverse the tree and build a linear recordset that I can feed to Crystal.
One idea I've contemplated is to create grouping on the fly, one nested group for each level in the tree. Some potential problems with this are performance, and running up against some upper limit as to the number of groups. I don't know if there is one, and if so, what it is. Also there is a finite width to the page, so indenting groups can only go so far and still have a usable output.
One advantage of this method is it would make use of Crystal's drill-down functionallity to see whatever level of detail the user wants.
Does anyone have any ideas about whether this would be practical, or any other approaches that might work? I could use the Report Designer Component if it has some control that would be useful. I've never used it so there would be a learning curve, and it would deviate from the architecture that is already in place with other reports built for this application. I'd rather avoid that if possible.
Is there any mechanism to include Active-X controls within a Crystal Report, such as in a subreport? If so, then I could use the same tree control that the application uses to allow manipulation of the data.
Scott
