I have created a parameter field that is a string input by the user.
I want to select records based on a field containing the characters the user entered in the parameter.
This is my formula in the record selection expert:
if( {?PartNum} <> '') then
{PART.ExternalNumber} like '({?PartNum})*'
I'm not getting any records selected and when I show the SQL query it is actually using the text of ({?PartNum})* instead of the value that the user input.
How do I get the record selection to use the value that the user input?
IP Logged
