Here is the code that I sent to Tech Support for testing the issue. Followed by the response from Tech Support. The outcome is they suggest to update the reports to have a -DEFAULT.
Create a report with the below code and run it adhoc
either from the DevStudio or
from BI Portal ( report can be either on the server or on the client). Now
create a schedule for the same and
Note: Not to enter any values for the prompt not even a space both as adhoc and
-SET &CNT = IF &COUNTRY EQ '' OR &COUNTRY EQ ' ' OR &COUNTRY EQ 'FOC_NONE' THEN
'FOC_NONE' ELSE &COUNTRY;
TABLE FILE CAR
WHERE COUNTRY EQ &CNT ;
When no values entered i get report when ran adhoc but with no values the
schedule is failing with an error
"A VALUE IS MISSING FOR: &COUNTRY"
If I enter atleast space in the parameters tab in the schedule or add -DEFAULT
&COUNTRY = ' ' ; in the FEX
file only then the schedule is working .
In 7 the schedule is working without space or without -DEFAULT.
That is the issue I was talking about.
---------------Tech Support Reply-------------
Thank you for the code. As a rule ReportCaster is stricter with the code than
when creating the report interactively. While a -Set does allow the reports to
run, the proper way is to first declare the variable with -default (setting it
to an initial value). This can even be left blank. Subsequently -set can be
used to set a variable to a literal value or to one computed in an expression.
With the increase in functionality in 8.x ReportCaster and webfocus in general
has become stricter in its interpretation.
So while the 7.x code allowed it, technically the correct usage is as required
by 8.x and the code will have to be changed.
WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012