[SOLVED] GAP BETWEEN MORE FILE OUTPUT AND GRAND TOTAL FOR EACH FILE
Hello, I got the below request, I appreciate any one have suggestion...
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
-*====================================
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'JAPAN';
ON TABLE HOLD AS HOLD2 FORMAT FOCUS
END
-*====================================
TABLE FILE HOLD1
PRINT CAR SALES
BY COUNTRY
ON TABLE HOLD AS HOLD3
MORE
FILE HOLD2
END
-*====================================
TABLE FILE HOLD3
PRINT *
END
CURRENT OUTPUT COUNTRY CAR SALES ENGLAND JAGUAR 0 ENGLAND JAGUAR 12000 ENGLAND JENSEN 0 ENGLAND TRIUMPH 0 JAPAN DATSUN 43000 JAPAN TOYOTA 35030 ====================== TOTAL 90030 ======================
USER WANTS THE OUTPUT GAP AND GRAND TOTAL BETWEEN FILE JUST LIKE BELOW EXAMPLE COUNTRY CAR SALES ENGLAND JAGUAR 0 ENGLAND JAGUAR 12000 ENGLAND JENSEN 0 ENGLAND TRIUMPH 0 ===================== TOTAL 12000 ===================== JAPAN DATSUN 43000 JAPAN TOYOTA 35030 ==================== TOTAL 78030 ====================This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
January 26, 2018, 11:07 AM
jfr99
TABLE FILE HOLD3
PRINT SALES
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"========================"
"TOTAL <ST.SALES "
"========================"
ON TABLE SET BYDISPLAY ON
END
WebFocus 8.201M, Windows, App Studio
January 26, 2018, 11:10 AM
MartinY
Simple as this
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
-*====================================
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'JAPAN';
ON TABLE HOLD AS HOLD2 FORMAT FOCUS
END
-*====================================
TABLE FILE HOLD1
PRINT CAR SALES
BY COUNTRY
ON TABLE HOLD AS HOLD3
MORE
FILE HOLD2
END
-*====================================
TABLE FILE HOLD3
SUM SALES
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL
ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
END
Then play with formatting (styling) as you wish.
Or even simplest depending if you really need to create HOLD file to then MORE them
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL
WHERE COUNTRY EQ 'ENGLAND' OR 'JAPAN';
ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
END
But if you need to create blank rows, jfr99 sample may be an option.
More fancy way to avoid blank line at the end
TABLE FILE CAR
SUM SALES
BY TOTAL COMPUTE ROWID /I1 = IF COUNTRY EQ LAST COUNTRY THEN ROWID ELSE ROWID + 1; NOPRINT
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
""
"Total <ST.SALES"
ON ROWID SUBHEAD
""
WHEN ROWID NE 1;
WHERE COUNTRY EQ 'ENGLAND' OR 'JAPAN';
ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
This message has been edited. Last edited by: MartinY,
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
January 26, 2018, 11:37 AM
v_ani
Thanks both of you, In my report I used file more option ,I don't want to upload all the code that is why I showed as CAR file Example.
After I posted , I added the breakpoint to my report its working. But only the HEADING is repeating every breakpoint.... This is the added to my report..
COMPUTE LINE/I4 WITH E01= IF LINE EQ 6 THEN 1 ELSE LINE+1; NOPRINT
COMPUTE BREAKPOINT/I4 = IF ((LINE EQ 6)) THEN BREAKPOINT+1 ELSE BREAKPOINT; NOPRINT
BY BREAKPOINT NOPRINT
ON BREAKPOINT PAGE-BREAK
ON BREAKPOINT SUB-TOTAL
HEADING
" <+0>&StartYear and January 1, &Year through <EndDate"
""
""
""
ON TABLE SUBFOOT
""
""