Hierarchical reports with ADO shape

[schetlur]

I have a shape command to fetch records with parent child relationships. Usually for 1 parent record, there are multiple child records.

I'm trying to get a hierarchical report in Access adp 2003. I have a shape command that looks like this:

SHAPE {exec dbo.usp_xxx '" & myID & "'} " _


& " APPEND ({exec dbo.yyy '" & myID & "'}" _
& " RELATE ID TO parameter 0) AS MyData"

How do I associate the subreport's recordset to the child records from the above query?