I am writing a report. I am using OVER key word to get % of my DATA for example,
Store Sale
% TOTAL SALE

When I do subtotal by colum and show back ground color in PDF as gray. It shows gray at two lines where as I am only getting subtotals one line.

I also want to remove extra blank space between subtotals. I also want to add a top border, but I am getting no where with this. I tried several things. I tried DROPBLNKLIN and border options but nothing is work.

TABLE FILE AGG_ARBYSCHOOL
-*ON TABLE SET PAGE-NUM OFF
-*ON TABLE COLUMN-TOTAL AS 'TOTAL'
-*ON TABLE SET HTMLCSS ON
SUM
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT/P11' AS ''
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT/P11' AS ''
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT/P11' AS ''
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT/P11' AS ''
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT/P11' AS ''
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT/P11' AS '' OVER
COMPUTE NEWCOL/D6.1% = ( 0TO6DEBIT * 100 / TOTALSPONSORDEBIT ); AS ''
COMPUTE NEWCOL/D6.1% = ( 100 * 7TO13DEBIT ) / TOTALSPONSORDEBIT; AS ''
COMPUTE NEWCOL/D6.1% = ( 100 * 14TO20DEBIT ) / TOTALSPONSORDEBIT; AS ''
COMPUTE NEWCOL/D6.1% = ( 100 * 21TO27DEBIT ) / TOTALSPONSORDEBIT; AS ''
COMPUTE NEWCOL/D6.1% = ( 100 * OVER28DEBIT ) / TOTALSPONSORDEBIT; AS ''
COMPUTE NEWCOL/D6.1% = ( 100 * TOTALSPONSORDEBIT ) / TOTALSPONSORDEBIT;
AS ''
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS ''
BY 'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.SCHOOLID' AS ''

ON J0.DIM_SCHOOL.DISTRICTNAME SUBTOTAL
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT'
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT'
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT'
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT'
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT'
'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT' AS 'Total'
HEADING
"Learning Care Group AR Report Weekending : " Private Agency"
" Pay Pay"
" "
" <+0>District <+0> School <+0> 0to6 <+0> <+0> 7to13 <+0> 14to20 <+0> 21to27 <+0>Over28 <+0>Tatal"
FOOTING
"Run Date <+0>&DATE <+0> <+0> PageON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.055556,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.041667,
BOTTOMMARGIN=0.041667,
SQUEEZE=0.555556,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=DATA,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N9,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N10,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N11,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N12,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N13,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N14,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N21,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N22,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N23,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N24,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N25,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N26,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N15,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N16,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N17,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N20,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N18,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N19,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N9,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N10,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N11,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N12,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N13,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N14,
FONT='ARIAL',
SIZE=9,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N21,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N22,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N23,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N24,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N25,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N26,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N15,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N16,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N17,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N20,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N18,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N19,
FONT='ARIAL',
SIZE=7,
COLOR='BLUE',
STYLE=NORMAL,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
HEADALIGN=BODY,
$
TYPE=HEADING,
LINE=1,
COLSPAN=7,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR='WHITE',
SIZE=10,
STYLE=UNDERLINE,
-* STYLE=BOLD,
-* BORDER-TOP=LIGHT,
$

TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N9,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N10,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N11,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N12,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N13,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N14,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.805556,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N3,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N4,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N5,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N6,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N7,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=REPORT,
COLUMN=N8,
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
ENDSTYLE
END

<\>
Any Idea?

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

WebFOCUS 7.6.10
Windows
HTML

Is there a chance for you to work a sample code that replicates this behaviour using the CAR table (or any other IBI-provided file) for us to take a look?

In addition, please follow this tip when posting your code.