Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report shows only 1 line from 2sd table
Message
De
23/09/1999 08:46:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00267754
Message ID:
00267928
Vues:
21
That was direction I was going in. I wanted to know why it worked in FPW 2.6 and not in VFP 5.

>>>>>>>>>
I find that the most stable way to prepare data for a report is to select everything into one cursor, then run the
report using that cursor. They you can group by to get your print out looking properly.

The side effect of using one report cursor is that the print preview button will work properly.
<<<<<<<<<

>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
>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform