Create a data group on Employee and put the employee information in the data group header band.

For the 1st detail band, define the target alias expression as the "deduction" table/cursor.

For the 2nd detail band, define the target alias expression as the "paymentschedule" table.

Select the employee cursor. Set relations to the other two tables. Run the report.


>I have the following tables
>
>employees
>join deduction on employees.payee_id
>join paymentschedule on employees.payee_id
>
>I need report:
>
>employee Name John Doe
> address etc...
> pay amount 1600.00
>____________________
>deduction:
> garnishment 200.00
> overpayment 4.50
>_____________________
>schedule:
> 12/24/2005 1600
> 01/07.2006 1600
> etc
>++++++++++++++++++++++
>
>employee Name Max Schmeling
> address etc...
> pay amount 8600.00
>____________________
>deduction:
> garnishment 900.00
>_____________________
>schedule:
> 12/24/2005 8600
> 01/07.2006 9600
> etc
>
>
>
>my report layout seems not to work
>
>how does on doe this kind of thing. I have never used the new reporting feature (double detail) stuff
>
>Peter