Focal Point
[SOLVED] DEFAULT issue after migration to 8008

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3347092276

August 21, 2014, 01:10 PM
Rao D
[SOLVED] DEFAULT issue after migration to 8008
Hi,

We have reports with parameters for example start_date, end_date. The user may or may not enter values. In 7703 the report works without any issue both from Adhoc and ReportCaster without any changes by leaving the prompts blank.

Recently we migrated to 8008 and the report works fine on ad-hoc with blank values. In Report Caster when no value is entered it is failing with an error 'A Value is missing for &START_DATE etc. To avoid this either I have to add a - DEFAULT &START_DATE = ''; in the FEX or in the Report Caster I have to manually enter space for the parameter in the parameters prompt.

Did anyone face such problems after migration? Any suggestions to avoid editing schedules or FEX files.

Thanks,

Rao.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio

August 27, 2014, 07:42 PM
<Kathryn Henning>
Hi Rao,

I see that you have an open case for this issue. Please let us know the outcome.

Thanks and regards,

Kathryn
September 24, 2014, 10:04 AM
Rao D
Kathryn,

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.

------------Code sent----------------
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
test it

Note: Not to enter any values for the prompt not even a space both as adhoc and
in reportcaster.

-*newfex.fex
-SET &CNT = IF &COUNTRY EQ '' OR &COUNTRY EQ ' ' OR &COUNTRY EQ 'FOC_NONE' THEN
'FOC_NONE' ELSE &COUNTRY;
TABLE FILE CAR
PRINT *
WHERE COUNTRY EQ &CNT ;
END

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
AppStudio