Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2 Tables Report
Message
 
 
À
24/09/2010 00:49:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Divers
Thread ID:
01482520
Message ID:
01482521
Vues:
64
>Dear Experts
>
>I have following codes
>
>
>Create table table1 (date d(8),title1 Char(15),name1 Char(20),amount n(5))
>
>Insert Into table1 Values ({^2009-01-05},'Report1','Page1',1)
>Insert Into table1 Values ({^2009-01-06},'Report1','Page2',2)
>Insert Into table1 Values ({^2009-01-07},'Report1','Page3',3)
>
>Create table table2 (date d(8),title1 Char(15),name1 Char(20),amount n(5))
>
>Insert Into table2 Values ({^2010-01-15},'Report2','Page1',1)
>Insert Into table2 Values ({^2010-01-16},'Report2','Page2',2)
>Insert Into table2 Values ({^2010-01-17},'Report2','Page3',3)
>
>REPORT FORM report1 PREVIEW nowait
>
>
>
>I want to display data from both tables, in Report1.
>When I press PageDown then data from Table2 is not updated.
>
>Form, Tables and Report is in attachment
>
>http://www.foxite.com/uploads/b702555b-db1b-4166-a5c1-3a38dabedf2a.zip

The simplest way to get this report is to create a cursor by joining the tables (I guess using UNION ALL) and then run this report from a cursor.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform