General information
Category:
Reports & Report designer
Hi Mark:
I am using a 2 digit field, this is my code below:
LPARAMETERS nInputYear
SELECT ;
Ilspm, ;
Status, ;
Start, ;
Comp, ;
Ssp, ;
Msr, ;
Avail, ;
Ship, ;
Hull, ;
Num_Chgs ;
FROM Schd ;
WHERE Val(left(SSP,2)) = nInputYear ;
INTO CURSOR Rptstatus4 ;
ORDER BY Ssp
select Rptstatus4
IF _TALLY > 0
REPORT FORM Rptstatus4 PREVIEW
ELSE
= MESSAGEBOX ("Sorry, there was no records matching your report criteria."), 0, (" Status Report ")
ENDIF
It look like INTO CURSOR Rptstatus4 ; code and below is not working.
Previous
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