Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED]Styling GRANDTOTAL line?
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED]Styling GRANDTOTAL line?
 Login/Join
 
Guru
posted
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
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1716 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1716 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
I use it on my production report.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Then you have to add the same BY to it. Add

BY CAR.ORIGIN.COUNTRY
after the SUM SALES NOPRINT.


WebFOCUS 8206, Unix, Windows
 
Posts: 1716 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try adding AS '' to this line:

ON TABLE COLUMN-TOTAL AS ''


WebFOCUS 8206, Unix, Windows
 
Posts: 1716 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2233 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2233 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED]Styling GRANDTOTAL line?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.