Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Ssp Number by Fiscal Year
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement