[SOLVED] Nested IF, ELSE, THEN Using DEFINE in InfoAssist+
Hi All
It might be a simple question and I am not aware of the answer.
is Nested IF, THEN ELSE possible within a DEFINE in InfoAssist+
As always, your responses are highly appreciated.This message has been edited. Last edited by: NewBee...WF8,
WebFOCUS 8 Windows, All Outputs
August 02, 2018, 03:21 PM
BabakNYC
Yes.
-*COMPONENT=Define_CAR
DEFINE FILE CAR
IF_THEN_ELSE/D12.2M=IF COUNTRY EQ 'ENGLAND' THEN CAR.BODY.SALES ELSE IF CAR EQ 'DATSUN' THEN SALES * 10 ELSE 0;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE
SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE CAR
SUM CAR.BODY.SALES
IF_THEN_ELSE
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END
-RUN
This message has been edited. Last edited by: BabakNYC,
WebFOCUS 8206, Unix, Windows
August 03, 2018, 08:49 AM
NewBee...WF8
quote:
Originally posted by BabakNYC: Yes.
-*COMPONENT=Define_CAR
DEFINE FILE CAR
IF_THEN_ELSE/D12.2M=IF COUNTRY EQ 'ENGLAND' THEN CAR.BODY.SALES ELSE IF CAR EQ 'DATSUN' THEN SALES * 10 ELSE 0;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE
SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE CAR
SUM CAR.BODY.SALES
IF_THEN_ELSE
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END
-RUN
Thank you BabakNYC for the example and a quick response. Appreciate it.