I have a report on which I selected Stack measure so I got 10 rows. Now I have to represent the first 6 rows as the first Section and there should be some space and the remaining 4 rows should be in the second section.
Tried everything but unable to achieve this scenario.
Need Help...Thank you in Advance.This message has been edited. Last edited by: NewBee...WF8,
WebFOCUS 8 Windows, All Outputs
April 20, 2018, 07:47 AM
BabakNYC
I think this is close to what you're looking for. First create a counter then divide them up into the first group and the second group.
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 ibisamp/car
SUM CAR.BODY.DEALER_COST
OVER CAR.BODY.RETAIL_COST
OVER CAR.BODY.SALES
OVER COMPUTE CNTR/I9=CNTR + 1 ; NOPRINT
OVER COMPUTE SKIP/I1=IF CNTR GT 6 THEN 1 ELSE 0 ; NOPRINT
BY TOTAL SKIP NOPRINT UNDER-LINE
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