Hi @Sam_SAS , I tried above solution and created calculated filter along with advance filter , my input textbox having alphanumeric value like ABC123 . so i kept input textbox as Character . In advance filter i used below code IF (GetWord('Loan Account No'n)>0) RETURN (( UpperCase('Loan Account No'n) Contains UpperCase('Parm1'n) ) OR ( UpperCase('Loan Account No'n) Contains LowerCase('Parm2'n) )) ELSE (1=1) this showing me an error as Expected : Numeric constant ,numeric, date or datetime . i dont know how to resolve this issue .
... View more
