using Hierarchical Recordsets w/ CR 8.5

[olichap]

It looks like I'll have to use an Hierarchical Recordset with CR (passed from a VB app). The CR doc says such recordsets are supported but does not elaborate on any special behavioral issues.

My recordset will consist of a partent and at least three child sets. How well does CR handle data passed in this manner? Does anyone know of any special considerations I should take into account prior to development? When I set the Report database location to a stored proc CR evaluates the procedure and recognizes fields returned by this singular recordset. How does CR interpret a Hierarchical recordset? I don't really plan on using a bound control, but if I were to use an ADO control bound to an SQL statement that has been Shaped will CR just see all the fields returned by the query, regardless of the multiple recordset layers?

Any info/advice I can get prior to this undertaking would be greatly appreciated.

Thanks,
Oliver

 

[kenhamady]

I am guessing here, but I would assume that it works with recordsets like it would work in a single table.

There needs to be one composite table with two colums, one referring to the other as a parent. If your recordset looks like that, then CR should be able to activate the Heirarchical Grouping feature in the report. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[olichap]

Thanks Ken,

I'm probably going to work-up a test report later today just to see how CR reacts.

O.