- The parent table should be the selected table when the report runs.
- There must be a relation defined between the child table and the parent table.
- There must be a relation defined between the 3rd table and the parent table.
- Create a data group on the parent
- Put the parent information in the data group header
- Set the target alias of the Detail1 band to the child table.
- Set the target alias of the Detail2 band to the 3rd table.
>I need to create a report where only one record of the parent table is printed, soon afterwards, all related records of the child table and soon afterwards, several records of a third table.
>
>Ex.: Table Order1 (Parent Table)
> print number of order, total of order, customer, etc.
>
> Table Order2 (Child Table)
> print identification of the product,amount,unitary value,total value
>
> Table Order3 (not related)
> print rules to receive the product (some records not related)
>
>I try use a multiple details band but for each record printed int first detail band (table Order2), one record is printed in the second detail band (table Order3).
>
>somebody can help myself?
>
>Thanks
>
>Renir