Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Report shows only 1 line from 2sd table
I have the following, simplified, report I am trying to create in VFP 5.
2 tables related by a common field. It is a 1-n relationship. Table 1 has a requisition nunber and table 2 has multiple 1 to n lines for each requisition number. The report writer only shows the first line in table 2 even if it as more lines. Table 1 is ordered by its primary key, code, which is not the common field and table 2 is sorted by common field and line number. How do I get the report to display
code1
reqno11 lineno11
lineno12
.
.
reqno12 lineno21
lineno22
.
.
code2
reqno21 lineno11
lineno12
.
.
What I get is lineno11 for all records in table 2
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