Focal Point
A VALUE IS MISSING FOR: &IBIMR_user?

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

February 26, 2008, 08:46 AM
Jason K.
A VALUE IS MISSING FOR: &IBIMR_user?
We have added a logging fex as an Include in many of our report fexes. This log fex uses IBIMR_user, and works just fine in MRE.

Unfortunately, this doesn't work so well in reportcaster. We're getting an error of
Task error: A VALUE IS MISSING FOR: &IBIMR_user

Is there a way to either ignore the -include if the job is a reportcaster job OR to prevent the error from occuring?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
February 26, 2008, 08:59 AM
Leah
You might be able to use a DEFAULT set up using dialog manager code in the include that if it isn't there set it to some set value. Of course syntax is not my area of expertise in dialog manager.


Leah
February 26, 2008, 09:23 AM
GinnyJakes
Since Report Caster runs under a completely different servlet than MRE and the WF client, many variables are not available. Maybe someone with more MRE experience can tell you whether you can get the MR variable in RC.

With that said, here is something you can do. We have a situation in our shop where certain secure data bases require an include for the connect string. This include can be run from WF and uses user credentials in the connect string. If it is run from RC, it looks up credentials in a data base. The include program knows what its environment is based on the setting of a flag, in our case RC_app. The person setting up the schedule must code a value for the RC_app parameter in the Advanced section of the Task tab. There is a -DEFAULT in the include program.

So, Leah, you were right! Smiler

Jason, let me know if you need more details.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
February 26, 2008, 11:03 AM
Jason K.
I think I understand.
You put if/then logic in the fex that requires mr_user variable and set a variable in reportcaster pre-process to say that "this is a reportcaster job, so goto end of my INCLUDE app"

so simple.


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
February 26, 2008, 12:04 PM
GinnyJakes
You've got it!


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google