i have 3 tables: balance, employee and orgfile

balance table has these fields: empno, effectdate, vl, sl
employee fields are: empno, lastname, firstname, orgcode
orgfile fields are: orgcode, desc


my balance table would have values like this
empno effecdate vl sl
0001 01/2003 0 1
0002 01/2003 0 0
0003 01/2003 0 0
0004 01/2003 0 2
0005 01/2003 0 0
0001 02/2003 0 0
0002 02/2003 2 0
0003 02/2003 0 0
0004 02/2003 0 1
0005 02/2003 0 0
0001 03/2003 0 0
0002 03/2003 0 1
0003 03/2003 0 0
0004 03/2003 0 0
0005 03/2003 1 0

i want to have a report layout like this


jan feb mar
vl sl vl sl vl sl

Paul McCartney 0 1 0 0 0 0




in my data environment, i add the 3 tables and relate empno from employee to balance, and orgcode of employee to orgfile.

however, when i set balance as the initialtable of my data environment, i don't get the right employee names.. (it displays only the first record of employee table)

if i set the employee table as the initialtable, i get all the employee's name displayed correctly but no value under the vl and sl column which is in the balance table.

can you help me, what should i do with this kind of report?