I am using vb6 with the data report and data environment.

I understand that reports usually follow the pattern:

Command
|
--Sub Command
|
--Sub Command

But in my data environment i have a command with the following structure:

Command
|
--Sub Command
--Sub Command

I am tring to display this in a report, but when i right click in the report and retrieve structure, i get the error "report writer does not support multidimensional hierarchies..."

So if i try to manually drag the items from the data environment to the report, i can drag the first sub commands properties, but not the second (i get the 'no entry' cursor).

Is it possible to create a report with this structure? Or should i split it into two seperate reports, one for each sub command?

Thanks