Crystal Reports Variable Parameters

[chubchub]

I want to add date parameters in query

WHERE A.SlpCode =  {?Slp@Select SlpCode, SlpName From OSLP} AND A.U_SCPNo IN {?SC@Select U_SCPNo,CardName From ORDR Where SlpCode = @Slp AND DocDate > '2021-01-01'}

WHERE A.SlpCode =  {?Slp@Select SlpCode, SlpName From OSLP} AND A.U_SCPNo IN {?SC@Select U_SCPNo,CardName From ORDR Where SlpCode = @Slp AND DocDate >= @frmdate}

sap2.jpg

[owaisk]

First create a @date parameter in crystal report command, then call it in query like > 'select * from oinv where docdate >= {@date}'.

Thanks.