Passing Multiple Parameter to Crystal Report

Ninnad Jagtap

Active member
Joined
Apr 12, 2005
Messages
35
Programming Experience
Beginner
hi all
Really hard . I have written a selection formula that select the value like this
crReportdocument = New crMISGateInAPM()
strSelFormula = "{Command.GAPGatePassDate} >= datetime(" & _
FromDate & ") And {Command.GAPGatePassDate} <= datetime(" & _
ToDate & ") And {Command.CMOLinerCode} = '" & Liner & "' And {Command.CMOEmptyStatus} IN ('" & ContainerType.Trim & "') "
ContainerType is String
here a problem for me is that when i Single value like
{Command.CMOEmptyStatus} IN ('E') then my report is generated but
when i pass value like
{Command.CMOEmptyStatus} IN ('E','F')
then it shows me error as -> ) is missing
So how do i pass Multiple values to my selection formula in crystal report .

 
Back
Top