How do I remove those lines after the GRANDTOTAL and set it to be only one line?
TABLE FILE CAR
SUM SALES NOPRINT
SUM SALES
BY COUNTRY
ACROSS CAR
COMPUTE X/D8 = C1; AS 'ACU'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT, SIZE=5, $
TYPE=TITLE, SIZE= 5, $
TYPE=DATA, SIZE=5,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=5, $
$
TYPE=HEADING,
LINE=2,
SIZE=9,
JUSTIFY=LEFT,
$
ENDSTYLE
ThanksThis message has been edited. Last edited by: <Emily McAllister>,
WebFOCUS 8.1.05 / APP Studio
January 13, 2016, 09:10 AM
BabakNYC
It's controlled by the following syntax which is in your endeflt.sty file.
If we remove the INCLUDE it will keep some weird spaces at TOTAL line.
It happens when we have a multi request. How do I remove it?
WebFOCUS 8.1.05 / APP Studio
January 13, 2016, 10:05 AM
BabakNYC
You have SUM SALES twice. Not sure why. If you get rid of that extra line problem goes away.
remove the following line right after TABLE FILE
SUM SALES NOPRINT
WebFOCUS 8206, Unix, Windows
January 13, 2016, 10:10 AM
Ricardo Augusto
I use it on my production report.
WebFOCUS 8.1.05 / APP Studio
January 13, 2016, 10:14 AM
BabakNYC
Then you have to add the same BY to it. Add
BY CAR.ORIGIN.COUNTRY after the SUM SALES NOPRINT.
WebFOCUS 8206, Unix, Windows
January 13, 2016, 10:27 AM
Ricardo Augusto
Its not that. I removed it from my prod report but it still add that weird space at the total line.
TABLE FILE HZ2
SUM SRSD83_RETAIL_SALES_Q/D8
BY HIGHEST VENTAS_MANUF NOPRINT
BY ACU_LAST_YEAR NOPRINT
BY VENTAS_TOTAL NOPRINT
BY MANUFACTURER AS ''
ACROSS MONTH NOPRINT
ACROSS MONTH_REPORT AS ''
COMPUTE ACU_TOTAL/I9 = VENTAS_TOTAL; NOPRINT
COMPUTE ACU_MANUF/D8 = VENTAS_MANUF; AS 'YTD'
COMPUTE PCT_MANUF/D8.1 = (VENTAS_MANUF/VENTAS_TOTAL)*100; AS 'YTD%'
COMPUTE ACU/D8 = ACU_LAST_YEAR; AS '&LAST_YEAR Acu'
COMPUTE ACU_AVG/D8 = ACU_LAST_YEAR/12; AS '&LAST_YEAR AVG'
IF SRSD83_RETAIL_SALES_Q GT 0
HEADING
""
"&TITLE"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=ACU, SEQUENCE=2,$
TYPE=REPORT, COLUMN=ACU_AVG, SEQUENCE=3,$
-* INCLUDE = endeflt,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=MANUFACTURER EQ 'FORD',
$
TYPE=REPORT, SIZE=5, $
TYPE=TITLE, SIZE= 5, $
TYPE=DATA, SIZE=5,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=5, $
TYPE=DATA,
COLOR='BLUE',
STYLE=BOLD,
MACRO=COND0001,
$
TYPE=HEADING,
LINE=2,
SIZE=9,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING, LINE=1, SIZE=8, BORDER-TOP = LIGHT, $
ENDSTYLE
END
WebFOCUS 8.1.05 / APP Studio
January 13, 2016, 10:34 AM
BabakNYC
Try adding AS '' to this line:
ON TABLE COLUMN-TOTAL AS ''
WebFOCUS 8206, Unix, Windows
January 14, 2016, 08:25 AM
MartinY
quote:
You have SUM SALES twice. Not sure why. If you get rid of that extra line problem goes away.
Notice that without SALES NOPRINT the SUM column title is not shown. When there is only one SUM field with ACROSS you need to duplicate that SUM field to see the column's title.
Also you shouldn't have twice the verb SUM if it's not a multiverb report.
Using the following you have the SUM title displayed and don't have the weird blank line in the TOTAL
TABLE FILE CAR
SUM SALES NOPRINT
SALES
BY COUNTRY
ACROSS CAR
COMPUTE X/D8 = C1; AS 'ACU'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT, SIZE=5, $
TYPE=TITLE, SIZE= 5, $
TYPE=DATA, SIZE=5,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=5, $
$
TYPE=HEADING,
LINE=2,
SIZE=9,
JUSTIFY=LEFT,
$
ENDSTYLE
END
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 14, 2016, 09:30 AM
Ricardo Augusto
Thanks MartinY, I noticed that. But if you check my production report you will see I have only one SUM.
If I remove this lines, GRAND TOTAL line looks good.
TABLE FILE CAR
SUM SALES NOPRINT
SALES
BY COUNTRY
ACROSS CAR
COMPUTE X/D8 = C1; AS 'ACU'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT, SIZE=5, $
TYPE=REPORT, COLUMN=X, SEQUENCE=2,$
TYPE=TITLE, SIZE= 5, $
TYPE=DATA, SIZE=5,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=5, $
$
TYPE=HEADING,
LINE=2,
SIZE=9,
JUSTIFY=LEFT,
$
ENDSTYLE
END
WebFOCUS 8.1.05 / APP Studio
January 14, 2016, 10:02 AM
Francis Mariani
The split total line is a relatively common problem that has existed since the beginning of time. It usually occurs when there is a NOPRINT and BY. It now looks like it also occurs when BY and ACROSS is used, with SEQUENCE in the stylesheet.
I would open a Tech Support case, this is the minimal code that can trigger the issue:
TABLE FILE CAR
SUM
SALES
BY COUNTRY
ACROSS CAR
COMPUTE ACU/D8 = C1;
ON TABLE SUB-TOTAL
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=ACU, SEQUENCE=99,$
END
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 14, 2016, 10:08 AM
MartinY
quote:
If I remove this lines, GRAND TOTAL line looks good. TYPE=REPORT, COLUMN=ACU, SEQUENCE=2, TYPE=REPORT, COLUMN=ACU_AVG, SEQUENCE=3,$
Sure the report does now look good, ACU and ACU_AVG doesn't exist in you TABLE FILE ... END
You cannot style something that doesn't exist in the internal matrix.
'ACU' is just a column's title that you've assigned.
What are you trying to accomplish with the following:
COMPUTE X/D8 = C1; AS 'ACU'
This is working well
TABLE FILE CAR
SUM SALES NOPRINT
SALES
BY COUNTRY
ACROSS CAR
COMPUTE X/D8 = C1; AS 'ACU'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT, SIZE=5, $
-*TYPE=REPORT, COLUMN=X, SEQUENCE=2,$
TYPE=TITLE, SIZE= 5, $
TYPE=DATA, SIZE=5,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=5, $
$
TYPE=HEADING,
LINE=2,
SIZE=9,
JUSTIFY=LEFT,
$
ENDSTYLE
END
Also, from your prod code, I will change :
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=ACU, SEQUENCE=2,$
TYPE=REPORT, COLUMN=ACU_AVG, SEQUENCE=3,$
-* INCLUDE = endeflt,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=MANUFACTURER EQ 'FORD',
$
TYPE=REPORT, SIZE=5, $
by
ON TABLE SET STYLE *
-* INCLUDE = endeflt,
-*$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=MANUFACTURER EQ 'FORD',
$
TYPE=REPORT, COLUMN=ACU, SEQUENCE=2,$
TYPE=REPORT, COLUMN=ACU_AVG, SEQUENCE=3,$
TYPE=REPORT, SIZE=5, $
I know that the "sequence" of the styling lines "may" not have any effect in certain cases, but the unnecessary $ may do a difference.
The $ indicate the end of a styling line
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 14, 2016, 10:48 AM
Ricardo Augusto
MartinY, of course my report have those columns at my prod report.
Ok Francis, I will open a case.
Thanks
WebFOCUS 8.1.05 / APP Studio
January 14, 2016, 01:17 PM
Francis Mariani
Ricardo, I would love to see what IBI Tech Support suggests to you to solve the problem. Please keep us posted!
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 14, 2016, 01:34 PM
Ricardo Augusto
I guess they will suggest to create a HOLD having fields at desired order before report it.