Pass parameters via weblink to retreive both upper case & lower case records in a report
Hi Gurus,
I have a web link pointing to a report and have the following parameters:
"&Options=rfd&Action=Navigate&p0=1&p1=like&p2="- Custom Object 1 Custom Attributes".TEXT_41&p3=1+%25%%%stFailed_Serial_Number%%%"
The field stFailed_Serial_Number contains both upper & lower alpha numeric characters. for example the characters can be either ABC123456789 or abc123456789.
if i give &p3=1+%25%%%stFailed_Serial_Number%%% or &p3=%%stFailed_Serial_Number%%%.. it would just give me just one record based on the case it was entered.
How do i display records in both upper & lower cases if the parameter passed is in upper case or lower case.