Hello,

I had a report similar to this in WebFocus 7703 and, in ReportCaster, the variables we set up were optional and it would run with at least 1 variable populated.

When I moved the report to WebFocus 8009, ReportCaster is now giving me an error that "A VALUE IS MISSING FOR &VARIABLE". Here's an example:

  
SET NODATA = ' '

DEFINE FILE CAR
SHOW_RTL/D7 MISSING ON = IF RETAIL LT 5000 THEN RETAIL ELSE MISSING;
END

TABLE FILE CAR
PRINT
CAR
MODEL
RETAIL
SHOW_RTL
BY COUNTRY
WHERE ( (COUNTRY EQ '&COUNTRY') OR
        (CAR EQ '&CAR')
      )
END

In WF7 RC, If I put &COUNTRY = ITALY and left &CAR null, it would run with all output where COUNTRY = ITALY.

In WF8 RC, If I put &COUNTRY = ITALY and left & CAR null, I'd get this error:

quote:

BTP1020 Executing focexec.
BTP1020 Connection to the Reporting Server EDASERVE closed at 2017-02-18 08:07:01.159-0800 (1,487,434,021,159)
BTP1020 Job ran on the Reporting Server EDASERVE for 0.0080 seconds
BTP1020 Task error: A VALUE IS MISSING FOR: &CAR
BTP1010 No report to distribute.

How do I fix this in WF8009 using ReportCaster?

Thank you

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

You could add defaults for the variables with -DEFAULTH.

You can use some pre process condition for variable-

-SET &CAR= (IF &CAR EQ '' OR &CAR EQ MISSING) THEN '_FOC_NULL' ELSE &CAR;

If &CAR is undefined,

-SET &CAR= (IF &CAR EQ '' OR &CAR EQ MISSING) THEN '_FOC_NULL' ELSE &CAR;

will trigger the same error message.

-DEFAULT &CAR='_FOC_NULL' 

at the top of the fex is necessary and sufficient.

Thanks all! I will give those a try.

I appreciate it and will post an update of what worked before marking this solved.

I used:

quote:

-DEFAULT &CAR='_FOC_NULL'

This worked for me using a report with about 13 variables. It's a template for monthly scheduled reports where one or more variables could be used, but not all.

Thank you all for your assistance!