I have been trying to use 1 report for both internal and external. Internal version accepts value from text box, external is populated by global parameter. I have used multiple ways to get this to work, but the externally always asks for the parameter. Below are 2 examples of what I have tried:

1st-
-SET &CODE = &&USER;
-SET &CODE1 = IF &CODE EQ _FOC_NULL THEN '' ELSE
- IF &CODE EQ '00000' THEN 'AND CMP.CODE = ''&PARAM_ENTRY''' ELSE
- 'AND CMP.CODE = ''&CODE''';

2nd-
-SET &CODE = &&USER.EVAL;
-SET &CODE_ENTRY = IF &CODE.EVAL EQ '00000' THEN &CODE_ENTRY ELSE &CODE;
-SET &CMPCODE = IF &CODE EQ _FOC_NULL THEN '' ELSE
- IF &CODE EQ '00000' THEN 'AND CMP.CODE = ''&CODE_ENTRY''' ELSE
- 'AND CMP.CODE = ''&CODE''';

Not sure what I am missing. Any help is appreciated. Thank you.

This message has been edited. Last edited by: FP Mod Chuck,

It appears all you're trying to do is populate a variable using IF THEN ELSE. Could you just describe what you'd like to put in the variable? Internal and external doesn't seem to be the issue at this level.

BabakNYC - I would like to put in global &&USER into the variable if their id code does not equal 00000. If it does equal 00000, then I want it to use value from text box on html page that user enters.

And if &&USER does not equal 00000, they must not be prompted for input.
Thank you.

Do you use WF Autoprompting or have built an HTML page from where the parameters are selected ?

Yes, using WF Autoprompting. Thank you.

Added -DEFAULTH to report to stop the auto prompt for external. Report is working for internal and external now. Thank you.

Really? Then what's triggering the Autoprompt?