Hi,

I am facing an issue with a variable name(i.e. &ISN in the below code ) which is something like - 'C&E Test Name'. When I enter this name in the filter page and run the report,I am getting an error like : -

(FOC295) A VALUE IS MISSING FOR: &E

The code is like -

-SET &ADN = IF &ISN EQ '' THEN '' ELSE 'IF @EVN EQ ''&ISN.EVAL''';
-SET &ADNFIL = IF &ISN EQ '' THEN '-' ELSE TRUNCATE(&ISN);
-TYPE ADN &ADN
-EXIT
Here itself I am getting this error.

Further I am using &ADN in creating the main filter condition -

-SET &WHR = ' IF @UID EQ &UID.EVAL ' |
-'IF @SID EQ ''&AUD.EVAL'' ' |
-'&ADN ';

Also,with the same code I am able to fetch records with names as 'Test C&E' and 'Hello C&E Test'.

Is there any way to fetch the 'C&E Test Name' value ?

Thanks.

This message has been edited. Last edited by: Kerry,

Try it with this line:

-SET &ADN = IF &ISN EQ '' THEN '' ELSE 'IF @EVN EQ ''' | &ISN | '''';

Thanks GamP.It worked.