Report based on complex ADO Shape


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Report based on complex ADO Shape

  1. #1
    PanamaAU Guest

    Report based on complex ADO Shape


    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

  2. #2
    Guest

    Re: Report based on complex ADO Shape


    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.

  3. #3
    JB Guest

    Re: Report based on complex ADO Shape


    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center