Here is my .fex
SET CENT-ZERO = ON
TABLE FILE FINANCIAL_MODELING_PORTAL
-*WHERE ClientName EQ &ClientName;
-*WHERE EvaluationDate EQ &EvaluationDate;
SUM
CurrPar/D20.2 AS 'Par'
PCT.CurrPar/D5% AS 'Weights'
COMPUTE WAGCpn/D12.2 = BCP_CPN / CurrPar; AS 'Cpn'
COMPUTE WAGWAL/D12.2 = BMV_WAL / BaseMV; AS 'Avg Life'
COMPUTE WAGDur/D12.2 = BMV_ED / BaseMV; AS 'Eff Duration'
COMPUTE WAGCon/D12.2 = BMV_CON / BaseMV; AS 'Eff Convexity'
BY ClientName NOPRINT
BY PORTFOLIO
WHERE ClientName EQ '&ClientName.(FIND FINANCIAL_MODELING_PORTAL.POSITIONHOLDINGS.ClientName IN FINANCIAL_MODELING_PORTAL).Institution Name.';
WHERE EvaluationDate EQ &EvaluationDate.(FIND FINANCIAL_MODELING_PORTAL.POSITIONHOLDINGS.EvaluationDate IN FINANCIAL_MODELING_PORTAL).Evaluation Date.;
WHERE SCENARIO EQ 0;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SUMMARIZE AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/FinancialModeling/alm_flat.sty,
$
TYPE=REPORT,
CALC-LOCATION=TOP,
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
JUSTIFY=LEFT,
PAGE-LOCATION=BOTTOM,
$
ENDSTYLE
END
And the parameters for my launch page are exactly the same as these two where statement.
my task2 set up as click "Run button" and refresh the whole portal page.
Thanks
WebFOCUS 8.1.05
Windows, All Outputs