Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Want Sort Order For Child table, But need fields from Ma
Message
 
À
01/12/1998 11:16:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00162751
Message ID:
00162805
Vues:
26
Create the cursor from wherever you call the report. Say for example you have a myreportbutton on a form for running this report, you might have something like this in the .Click:

SELECT .......... INTO CURSOR cMyReport
REPORT FORM PREVIEW

You would reference fields from cMyReport in your report.

>Thanks for the quick reply to my problem. I don't know how to place SQL in my properties, but, I will try dragging the relationship from the child to the master in the data environment. Thank you so much! (PS Where would I look to learn how to create the SQL and WHERE to put it) I do know how to view, cut, and paste SQL that has been generated, but have no clue how to use it in the properties.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform