VB6 and Crystal report - parameter passing
Posted on 2004-10-12
I am using VB6 and crystal reports8.5
I have a field in which the user enters data and
which then generates report accordingly.
In crystal reports i have set the parameter field
as param1 - strings.
In crystal reports I have put an SQL query
SELECT YEAR,CITYCODE, HOTELNAME
(CITYCODE = ' '' & param1 & " ' )
AM I allowed to enter my param1 in my
SQL Query . If yes then how ??
and I also want to pass my param1 value from VB6
not by any prompt from CR8.5
In vb6 code I have entered as
cr1.ParameterFields(1) = "param1;" & Combo1.Text & "; TRUE"
Am I doing something wrong somewhere ??? Pls advise