General information
Category:
Reports & Report designer
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only