The requirement is to format data from 3 independent temp tables created during a process on the same report, where in the 3rd table needs "hierachical data shaping".

To solve this , a data enviroment was created with 3 commands of SQL type and this data environment was associated as the data source for the report, with the fields refering to the 3 individual command recordsets. But it fails when executed.

You pointers/suggestions would be highly appreciated.