Report based on complex ADO Shape

[PanamaAU]

I am trying to create a report that will have 3 subreports based on children
tables and one parent table with a peer table. (think of it as a history
report for a car, with top data of serial no., mfr. date, etc., then a list
of serialized parts, then a list of maintenance actions, and then a list
of repair actions).

I can get the report based on the following Shape to work with ONE child
table only. The Shape works fantastic, but when I retrieve the structure
for the report, I get the error msg:

WARNING: Report Writer does not support multidimensional hierarchies. At
least one DataMember('sqlRigInfo') contains a multidimensional hierarchy,
part of which will be ignored.

The Shape command is:

SHAPE {SELECT WEAPONS.RIGNO, WEAPONS.STATUS, WEAPONS.NMAGDATE, WEAPONS.RIGDATE,
WEAPONS.KEYCODE, DIVES.DIVES_ASOF, DIVES.TOT_DIVEHR, DIVES.TOT_DIVES, WEAPONS.ACTIVITY
FROM WEAPONS, DIVES WHERE WEAPONS.RIGNO = DIVES.RIGNO (+) AND (WEAPONS.RIGNO
= '0009')} AS sqlRigInfo APPEND ({SELECT * FROM "RECFAR"."WEAPONCOMPONENTS"}
AS subWEAPONCOMPONENTS RELATE 'RIGNO' TO 'RIGNO') AS subWEAPONCOMPONENTS,({SELECT
* FROM "RECFAR"."FAILURES"} AS subFAILURES RELATE 'RIGNO' TO 'RIGNO') AS
subFAILURES

TIA

The current implementation of DataReport will accept only a one-dimensional
(one child per parent) relationship only.

This could have been a very valuable feature if it had the multi-dimensional
capability.

[JB]

I have similar needs, did you find a solution?

"PanamaAU" <PanamaAU@knology.net> wrote:
>
>I am trying to create a report that will have 3 subreports based on children
>tables and one parent table with a peer table. (think of it as a history
>report for a car, with top data of serial no., mfr. date, etc., then a list
>of serialized parts, then a list of maintenance actions, and then a list
>of repair actions).
>
>I can get the report based on the following Shape to work with ONE child
>table only. The Shape works fantastic, but when I retrieve the structure
>for the report, I get the error msg:
>
>WARNING: Report Writer does not support multidimensional hierarchies.
At
>least one DataMember('sqlRigInfo') contains a multidimensional hierarchy,
>part of which will be ignored.
>
>The Shape command is:
>
> SHAPE {SELECT WEAPONS.RIGNO, WEAPONS.STATUS, WEAPONS.NMAGDATE, WEAPONS.RIGDATE,
>WEAPONS.KEYCODE, DIVES.DIVES_ASOF, DIVES.TOT_DIVEHR, DIVES.TOT_DIVES, WEAPONS.ACTIVITY
>FROM WEAPONS, DIVES WHERE WEAPONS.RIGNO = DIVES.RIGNO (+) AND (WEAPONS.RIGNO
>= '0009')} AS sqlRigInfo APPEND ({SELECT * FROM "RECFAR"."WEAPONCOMPONENTS"}
> AS subWEAPONCOMPONENTS RELATE 'RIGNO' TO 'RIGNO') AS subWEAPONCOMPONENTS,({SELECT
>* FROM "RECFAR"."FAILURES"} AS subFAILURES RELATE 'RIGNO' TO 'RIGNO') AS
>subFAILURES
>
>TIA