How do you pass parameters into crystal report 8.5. I know how to do it using the data environment and report designer that comes with visual basic 6.0 but I tried using the sql statement that I designed in the data environment but it always says that some required parameter is missing and I can't us it. Just wondering how you do this in a crystal report.
Here is the sql code that I have in the data environment.
SELECT MEMBERS.IDNO, MEMBERS.FIRSTNAME,
MEMBERS.LASTNAME, GENTYPES.`DESC`,
MEMBERS.GENDATEPD, MEMBERS.GENAMTPD,
MEMBERS.GENCHECKNO, MEMBERS.GENEXPIRES
FROM MEMBERS, GENTYPES
WHERE MEMBERS.GENTYPE = GENTYPES.GENTYPE AND
(GENTYPES.GENTYPE = pType)
ORDER BY MEMBERS.IDNO
"pType is a string parameter"
Any help will be appreciated.
Thank you,
Derek J. Klingman
System Programmer
Micro League Software
www.MicroLeagueSoftware.com