Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Designing report getting values from 2 tables
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement