Focal Point
[CASE-OPENED]Styling GRANDTOTAL line?

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

January 13, 2016, 08:38 AM
Ricardo Augusto
[CASE-OPENED]Styling GRANDTOTAL line?
Hi,

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
 






Thanks

This 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.

type=grandtotal,
backcolor=rgb(66 70 73),
color=rgb(255 255 255),
style=bold,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(66 70 73),
border-top-style=solid,
border-bottom-style=double,
$


WebFOCUS 8206, Unix, Windows
January 13, 2016, 09:44 AM
Ricardo Augusto
Right. Thanks!

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.

TYPE=REPORT, COLUMN=ACU, SEQUENCE=2,
TYPE=REPORT, COLUMN=ACU_AVG, SEQUENCE=3,$
  



Any suggestions?


 
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.

I will post their reply here when I have it.

See ya


WebFOCUS 8.1.05 / APP Studio