Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New With FoxPro
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00333324
Message ID:
00333883
Vues:
17
Freddie,
Are you trying to produce a report that limits data to the ShipName and CompleteDate entered by the user? If so then there are at least 2 ways:

1. Make a cursor which contains just the data for the report, then run the report as Sylvain said.

SELECT * from MyTable where ShipName = thisform.txtShipName.value AND CompleteDate = thisformlCompleteDate.value into cursor RptCursor
Report Form MyReport && Report uses RptCursor for its data

2. Use the "FOR" clause in the Report command:
SELECT MyTable
Report Form MyReport for ShipName = thisform.txtShipName.value AND CompleteDate = thisformlCompleteDate.value

My preference is STRONGLY for method (1). With a cursor you have a snapshot of the data, you can order it and massage it any way you wish before you start to print the report.

HTH
Barbara

>Example: User Enter these Fields thru Forms screen
>
>txtShipName - Text box containing the Ship Name
>txtCompleteDate - Text box containing the Complete Date
>cmdRunReport - button will be use to fire the form
>
>Question: What is a fast way of creating cmdRunreport button
>on the form?
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform