"Multidimensional Hiearchies" in vb data report
I am using vb6 with the data report and data environment.
I understand that reports usually follow the pattern:
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