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>,

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,
$

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?

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

I use it on my production report.

Then you have to add the same BY to it. Add

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

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
  

Try adding AS '' to this line:

ON TABLE COLUMN-TOTAL AS ''

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

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

 

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

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

MartinY, of course my report have those columns at my prod report.


Ok Francis, I will open a case.

Thanks

Ricardo, I would love to see what IBI Tech Support suggests to you to solve the problem. Please keep us posted!

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