Focal Point
[Solved]Border line display in subtotals and total

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

May 15, 2012, 03:44 AM
SriAravind
[Solved]Border line display in subtotals and total
I want to display the borders properly for subtotals and total.Below is my sample code:

  
SET BYDISPLAY = ON
DEFINE FILE CAR
ST_TEXT1/A50 = '&|nbsp;&|nbsp;SubTotal:' || COUNTRY ;
ST_TEXT2/A100 = '&|nbsp;&|nbsp;&|nbsp;&|nbsp;SubTotal:' || CAR;

SH_TEXT1/A150 = '&|nbsp;&|nbsp;&|nbsp;&|nbsp;Country:hhjkhkj uih uhui hkhui j uih uihkhjkh uiuihihhi ' || COUNTRY;
SH_TEXT2/A150 = '&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;Car:' || CAR;
SH_TEXT3/A250 = '&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;Bodytype:' || BODYTYPE;
ST_TEXT4/A30 = 'Total:' ;

END
TABLE FILE CAR
PRINT
MODEL
SALES
SEATS
LENGTH
WIDTH
RETAIL_COST
DEALER_COST
SH_TEXT1 NOPRINT
SH_TEXT2 NOPRINT
SH_TEXT3 NOPRINT
ST_TEXT1 NOPRINT
ST_TEXT2 NOPRINT
ST_TEXT4 NOPRINT

BY COUNTRY NOPRINT
BY CAR NOPRINT
BY BODYTYPE NOPRINT

ON COUNTRY SUBHEAD
 "<SH_TEXT1"
ON CAR SUBHEAD
 "<SH_TEXT2"
ON BODYTYPE SUBHEAD
 "<SH_TEXT3"

ON COUNTRY SUBTOTAL SALES SEATS AS 'SubTotal:'
ON CAR SUBTOTAL SALES SEATS AS '&|nbsp;&|nbsp;&|nbsp;&|nbsp;SubTotal:'
ON BODYTYPE SUBTOTAL SALES SEATS AS '&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;SubTotal:'

ON TABLE SET HTMLCSS OFF
ON TABLE SET PAGE NOLEAD
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *

     UNITS=IN,
     LEFTMARGIN=0,
     RIGHTMARGIN=0,
     TOPMARGIN=0,
     BOTTOMMARGIN=0,
     SQUEEZE=ON,
  TITLETEXT=Report,
$
TYPE=REPORT,
   GRID=OFF,
     ORIENTATION=LANDSCAPE,
     FONT='ARIAL',
     SIZE=8,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
  LEFTGAP=.04,
  RIGHTGAP=.04,
  BOTTOMGAP=.04,
  TOPGAP=.04,
  BORDER=LIGHT,
  BORDER-COLOR=RGB(204 204 204),
  SCROLLHEIGHT=3.4,

$

TYPE = TITLE,STYLE=-UNDERLINE+BOLD,WRAP = OFF,BACKCOLOR = RGB(247 247 247),FONT='ARIAL',SIZE=10,
BORDER-TOP-COLOR=RGB(204 204 204),BORDER-LEFT-COLOR=RGB(204 204 204),BORDER-RIGHT-COLOR=RGB(204 204 204),BORDER-BOTTOM-COLOR=RGB(0 0 0),
$

TYPE = DATA,WRAP = ON,$

TYPE=SUBHEAD,WRAP = ON,  BOTTOMGAP=.02,TOPGAP=.02,HEADALIGN=BODY, $
TYPE=SUBHEAD,BY =1,LINE = 1,SIZE=9, STYLE = BOLD,BACKCOLOR=RGB(236 241 247),COLSPAN=7, $
TYPE=SUBHEAD,BY =2,LINE = 1,SIZE=9, STYLE = BOLD,BACKCOLOR=RGB(236 241 247),COLSPAN=7, $
TYPE=SUBHEAD,BY =3,LINE = 1,SIZE=9, STYLE = BOLD,BACKCOLOR=RGB(236 241 247),COLSPAN=7, $

TYPE=SUBTOTAL, BY=1,SIZE=9, STYLE=BOLD,$
TYPE=SUBTOTAL, BY=2,SIZE=9, STYLE=BOLD,$
TYPE=SUBTOTAL, BY=3,SIZE=9, STYLE=BOLD,$

TYPE=GRANDTOTAL,SIZE=9,     STYLE=BOLD,$

ENDSTYLE
END
-RUN

Below is the result i got(i've shown part of subtotals and total):



In the above result there is no borders at few places and its not uniform.

I need to display in the format as shown below:



Any help would be appreciated.

This message has been edited. Last edited by: SriAravind,


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
May 15, 2012, 09:47 AM
SriAravind
Adding one more issue to this......

If i replace
  
ON COUNTRY SUBTOTAL SALES SEATS AS 'SubTotal:'

as
 
ON COUNTRY SUBTOTAL SALES SEATS AS 'SubTotal: hhjkhkj uih uhui hkhui j uih uihkhjkh uiuihihhi'

then the width of first column is getting increased as shown below and this might be a odd behaviour for bigger name..




WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
May 18, 2012, 04:00 AM
SriAravind
Issue is solved. This is my code:
 
SET BYDISPLAY = ON
DEFINE FILE CAR
SH_TEXT1/A150 = '&|nbsp;&|nbsp;&|nbsp;&|nbsp;Country:' || COUNTRY;
SH_TEXT2/A150 = '&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;Car:' || CAR;
SH_TEXT3/A250 = '&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;Bodytype:' || BODYTYPE;
BLANK/A10 = '&|nbsp;  ';

END
TABLE FILE CAR
PRINT
MODEL
SALES
SEATS
LENGTH
WIDTH
RETAIL_COST
DEALER_COST
BY COUNTRY
BY CAR
BY BODYTYPE
BY BLANK NOPRINT
ON COUNTRY SUBHEAD
 "<SH_TEXT1"
ON CAR SUBHEAD
 "<SH_TEXT2"
ON BODYTYPE SUBHEAD
 "<SH_TEXT3"
ON COUNTRY SUBTOTAL SALES SEATS AS 'SubTotal:'
ON CAR SUBTOTAL SALES SEATS AS '&|nbsp;&|nbsp;&|nbsp;&|nbsp;SubTotal:'
ON BLANK SUBTOTAL SALES SEATS AS ''

ON TABLE SET HTMLCSS OFF
ON TABLE SET PAGE NOLEAD
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *

     UNITS=IN,
     LEFTMARGIN=0,
     RIGHTMARGIN=0,
     TOPMARGIN=0,
     BOTTOMMARGIN=0,
     SQUEEZE=ON,
  TITLETEXT=Report,
$
TYPE=REPORT,
   GRID=OFF,
     ORIENTATION=LANDSCAPE,
     FONT='ARIAL',
     SIZE=8,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
  LEFTGAP=.04,
  RIGHTGAP=.04,
  BOTTOMGAP=.04,
  TOPGAP=.04,
  BORDER=LIGHT,
  BORDER-COLOR=RGB(230 230 230),
  SCROLLHEIGHT=3.4,

$
-*TYPE=REPORT,HFREEZE=ON,$

TYPE = TITLE,STYLE=-UNDERLINE+BOLD,WRAP = OFF,BACKCOLOR = RGB(247 247 247),FONT='ARIAL',SIZE=9,BORDER-BOTTOM-COLOR=RGB(0 0 0),
-*BORDER-TOP-COLOR=RGB(204 204 204),BORDER-LEFT-COLOR=RGB(204 204 204),BORDER-RIGHT-COLOR=RGB(204 204 204),BORDER-BOTTOM-COLOR=RGB(0 0 0),
$
TYPE=FOOTING,BORDER = OFF, WRAP = ON, $
TYPE = DATA,WRAP = ON,$

TYPE=SUBHEAD,WRAP = ON,  BOTTOMGAP=.02,TOPGAP=.02,HEADALIGN=BODY, $
TYPE=SUBHEAD,BY =1,LINE = 1,SIZE=9, STYLE = BOLD,COLSPAN=7, $
TYPE=SUBHEAD,BY =2,LINE = 1,SIZE=9, STYLE = BOLD,COLSPAN=7, $
TYPE=SUBHEAD,BY =3,LINE = 1,SIZE=9, STYLE = BOLD,BACKCOLOR=RGB(236 241 247),COLSPAN=7, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP=OFF, BORDER-BOTTOM=OFF, $

TYPE=SUBTOTAL, BY=1,SIZE=9, STYLE=BOLD,BORDER=OFF,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-TOP-COLOR=BLACK, $
TYPE=SUBTOTAL, BY=1,COLUMN=P10,SIZE=9, STYLE=BOLD,BORDER-RIGHT=LIGHT, $
TYPE=SUBTOTAL, BY=1,COLUMN=P1,SIZE=9, STYLE=BOLD,BORDER-LEFT=LIGHT, $

TYPE=SUBTOTAL, BY=2,SIZE=9, STYLE=BOLD,BORDER=OFF,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-BOTTOM-COLOR=BLACK, $
TYPE=SUBTOTAL, BY=2,COLUMN=P10,SIZE=9, STYLE=BOLD,BORDER-RIGHT=LIGHT, $
TYPE=SUBTOTAL, BY=2,COLUMN=P1,SIZE=9, STYLE=BOLD,BORDER-LEFT=LIGHT, $

TYPE=SUBTOTAL, BY=BLANK,SIZE=9, STYLE=BOLD,BORDER=OFF,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT, $
TYPE=SUBTOTAL, BY=BLANK,COLUMN=P10,SIZE=9, STYLE=BOLD,BORDER-RIGHT=LIGHT, $
TYPE=SUBTOTAL, BY=BLANK,COLUMN=P1,SIZE=9, STYLE=BOLD,BORDER-LEFT=LIGHT, $

TYPE=GRANDTOTAL, SIZE=9, STYLE=BOLD,BORDER=OFF,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT, $
TYPE=GRANDTOTAL, COLUMN=P10,SIZE=9, STYLE=BOLD,BORDER-RIGHT=LIGHT, $
TYPE=GRANDTOTAL, COLUMN=P1,SIZE=9, STYLE=BOLD,BORDER-LEFT=LIGHT, $
ENDSTYLE
END
-RUN



WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML