Focal Point
[SOLVED] Parameter Option

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

March 02, 2017, 12:01 PM
v_ani
[SOLVED] Parameter Option
Hello,

I would like to set up two parameter option in the report 1. Reportcaster parameter 2. User run report Manually.


If the reporcaster schedules runs I want to use the below parameter .

-MRNOEDIT -INCLUDE baseapp/CalCurrentYrPdWk.fex
-MRNOEDIT -INCLUDE baseapp/rcdatefunctiondoco.fex
-MRNOEDIT -INCLUDE baseapp/rcdatefunctionbopp.fex
-SET &STARTDATE = &RCdate;
-MRNOEDIT -INCLUDE baseapp/rcdatefunctioneopp.fex
-SET &ENDDATE = &RCdate;


if the user runs this report manually, I would like to give the user the below parameter

-DEFAULT &DATERANGE = 'CALFSPD';
-INCLUDE IBFS:/WFC/Repository/Common/DateCalc.fex



I appreciate anyone help me on this issue.

Thnak you,

V_ani

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


WebFOCUS 8
Windows, All Outputs
March 02, 2017, 01:34 PM
MartinY
Basic programming coding:

-IF &RUNBY EQ 2 THEN GOTO RUNBYUSR;

-MRNOEDIT -INCLUDE baseapp/CalCurrentYrPdWk.fex
-MRNOEDIT -INCLUDE baseapp/rcdatefunctiondoco.fex
-MRNOEDIT -INCLUDE baseapp/rcdatefunctionbopp.fex
-SET &STARTDATE = &RCdate;
-MRNOEDIT -INCLUDE baseapp/rcdatefunctioneopp.fex
-SET &ENDDATE = &RCdate;
-GOTO RUNRPT

-RUNBYUSR
-*-DEFAULT &DATERANGE = 'CALFSPD';
-DEFAULTH &DATERANGE = 'CALFSPD';
-INCLUDE IBFS:/WFC/Repository/Common/DateCalc.fex
-RUNRPT



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
March 02, 2017, 03:40 PM
v_ani
MartinY,
Thanks you it works now. Before I post this issue I also tried the Goto statement in the top of the line. that is why I got wrong output before. Now I got it right.

Thank you


WebFOCUS 8
Windows, All Outputs