TABLE FILE COMCLASS_MOVEMENT
SUM
totCost NOPRINT
totSRP NOPRINT
totbydepcase NOPRINT
Departtotprof NOPRINT
DepartmentTotProfit NOPRINT
cITEMS NOPRINT
cITEMSC NOPRINT
NOcITEMS NOPRINT
NOcITEMS NOPRINT
departcost NOPRINT
NOcITEMS NOPRINT
cITEMS NOPRINT
cITEMSC NOPRINT
COMPUTE DepCost/D10.2 = totCost; NOPRINT AS 'DepCost'
COMPUTE DepSRP/D10.2 = totSRP; NOPRINT AS 'DepSRP'
COMPUTE DepCase/D10 = totbydepcase; NOPRINT AS 'DepCase'
COMPUTE DepProf/D10.2 = Departtotprof; NOPRINT AS 'DepProf'
COMPUTE DepartmentProfit/D10.2 = DepartmentTotProfit; NOPRINT
AS 'DepartmentTotProfit'
COMPUTE TOTPCTPRODEP/D9.2 = ( TotalProfit / totSRP ) * 100; NOPRINT
COMPUTE totalcases/I7 = CaseDel; NOPRINT
COMPUTE totalcostdepart/D12.2 = totCost; NOPRINT
COMPUTE totaltotal/D12.2 = totSRP - totCost + cITEMSC; NOPRINT
AS 'totaltotal'
COMPUTE gtotbydepcase/I7 = TOT.totbydepcase + TOT.cITEMS + TOT.NOcITEMS; NOPRINT
COMPUTE gtotcost/D12.2 = TOT.totCost; NOPRINT
COMPUTE gtotalprof/D12.2 = TOT.totSRP - TOT.departcost; NOPRINT
COMPUTE gpercentprof/D12.2 = ( TOT.totSRP - TOT.departcost ) / TOT.totSRP * 100; NOPRINT
BY IN_CUSTNO NOPRINT
BY DepartOrder NOPRINT
BY IN_DEPARTMENT NOPRINT

ON IN_CUSTNO SUBFOOT
" "
" <+0> <+0> <+0> CASES PURCHASED <+0> TOTAL COST <+0> TOTAL RETAIL <+0> TOTAL PROFIT PER CRP <+0> PERCENT OF PROFIT <+0> DEPT % TO COST <+0> DEPT % TO RETAIL"
" "
ON IN_CUSTNO SUBFOOT
" "
"Grand Total"
" <+0> <+0>REGULAR_PRICED_ITEMS " <+0> <+0>COST_ITEMS_(STORE_SUPPLIES)" <+0> <+0>NO_COST_ITEMS_(ORDER_SUPPLIES)" <+0> <+0>TOTAL" "

ON DepartOrder SUBFOOT
" "
" " <+0> <+0>REGULAR_PRICED_ITEMS " <+0> <+0>COST_ITEMS_(STORE_SUPPLIES)" <+0> <+0>NO_COST_ITEMS_(ORDER_SUPPLIES)" <+0> <+0>TOTAL" "

ON IN_DEPARTMENT SUBFOOT
" "
" <+0> <+0> <+0> CASES PURCHASED <+0> TOTAL COST <+0> TOTAL RETAIL <+0> TOTAL PROFIT PER CRP <+0> PERCENT OF PROFIT <+0> DEPT % TO COST <+0> DEPT % TO RETAIL"
" "

HEADING
""
"TEST"


WHERE ( IN_CUSTNO EQ 51600 ) AND ( IN_DATE GE DT(2011-04-30 00:00:00) ) AND ( IN_DATE LE DT(2011-05-06 00:00:00) ) AND ( PartSw NE 1 );
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=TABFOOTING,
JUSTIFY=RIGHT,
HEADALIGN=BODY,
$
TYPE=HEADING,
LINE=1,

JUSTIFY=CENTER,
HEADALIGN=BODY,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=SUBFOOT,
SIZE=8,
JUSTIFY=LEFT,
HEADALIGN=BODY,
$
ENDSTYLE
END



The heading ends up on the left hand side at the top and slides the data to the right, How would I center the title, either center it over the data or center it compared to the browser window, either one will work.


Also, how would it be possible to make a subhead act the same way as the subfoots are as they line up in coloumns and have the headings for each column, currently they repeat after every IN_DEPARTMENT, but i would like to have just one subhead on IN_CUSTNO


Thanks for the help!

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

TYPE=TITLE, SIZE=10, STYLE=BOLD, JUSTIFY=CENTER, BACKCOLOR=WHITE,$

For some reason that code does not appear to be working, i am still ending up with the title in the top left portion of the screen...

I dont know what i need to be doing to line this up in the center of the browser/data

TITLE is for column titles.
HEADING is for page headings.

TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
HEADALIGN=BODY,
$

HEADALIGN=BODY will force the report heading to be aligned to the first report column, remove HEADALIGN=BODY or add COLSPAN=nn to have the heading span multiple report columns.

Additionally, HEADALIGN=BODY must be set for all lines of a HEADING, it can't be set for just one line.