Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ssp Number by Fiscal Year
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Ssp Number by Fiscal Year
Divers
Thread ID:
00351442
Message ID:
00351442
Vues:
52
Hi:

My SSP number is 6 digits long and the first two digit consist of the
year. 92-082, 92-089, 93-090, 94-001.

The user must be able to select the first two digits of SSP number which stands for year. A report will be generated base on year input. If user select year 94 then all 94 data will be printed.

The final report will print out all of 94's data.

Form will consist of two fields:

A. TxtSpFiscalyear --- 2 digit field
B. CmdRunReport --- button use to fire the form

My code logic will look like this.

SELECT ;
Ssp ;
FROM Table ;
WHERE SSP(2) = THISFORM.TxtSpFiscalYear.Value ;
INTO CURSOR Output ;
ORDER BY OrderFields

-----------------------------------------------------------------
Questions

1. Where can I find sample FoxPro programs using Forms and passing
input slecting data for reporting outputs.

2. I know how to do this in other programming languages but not FoxPro. I am new to FoxPro, with no training.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform