Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ssp Number by Fiscal Year
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Ssp Number by Fiscal Year
Miscellaneous
Thread ID:
00351442
Message ID:
00351442
Views:
51
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
Map
View

Click here to load this message in the networking platform