Focal Point
[SOLVED] StackMeasure InfoAssist+

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

April 20, 2018, 12:16 AM
NewBee...WF8
[SOLVED] StackMeasure InfoAssist+
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

 



WebFOCUS 8206, Unix, Windows
April 22, 2018, 05:22 PM
NewBee...WF8
Thank you BabakNYC for the solution.


WebFOCUS 8
Windows, All Outputs