Data Report with Shaped recordsets?

[Vachaun22]

I am trying to build a data report from a shaped recordset that's created in code from other recordsets.

As it stands right now, the Shaped recordset is 3 layers deep (ie. there is a parent, child, and grandchild).

When I try to display that data on the data report, I'm getting the message:

Report sections do not match data source

What I need are the Child and Grandchild data to be shown in the details section. Currently the data report is setup with these sections:

Report Header
Page Header
Group Header (only 1)
Detail
Group Footer
Page Footer
Report Footer

Am I required to have another Group Header/Footer because there is 3 layers to the data source? Or is there another problem?

 

[genomon]

Grandchild data will print in the detail section - you need two headers...

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.