I need the last item on row one of the subfoot that is highlighted in red to line up with column five of the report. Using   is not giving me the expected results. This report is run using an Excel macro template and using SHOWBLANKS = ON causes the macro not to run. Therefore, I cannot use SHOWBLANKS = ON

 


-SET &BLANK='&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;';
DEFINE FILE CAR
BLANK/A1   = '';
BLANK1/A1  = '';
BLANK1A/A1 = '';
BLANK2/A1  = '';
BLANK3/A1  = '';
BLANK4/A1  = '';
FILLER/A1  = '';
FILLER2/A1 = '';
FILLER3/A1 = '';
SALES2/I6 = SALES;
CARCNT/I6 = 1;
END
TABLE FILE CAR
HEADING
"Testing Border in Subfoot  "
" "
SUM RCOST DCOST SALES2 RCOST DCOST SALES
CARCNT NOPRINT
BY FILLER3 NOPRINT
BY BLANK   NOPRINT
BY BLANK1  NOPRINT
BY BLANK1A NOPRINT
BY BLANK2  NOPRINT
BY BLANK3  NOPRINT
BY CAR
BY COUNTRY
BY FILLER  NOPRINT
BY FILLER2 NOPRINT
ON FILLER RECOMPUTE
SUM. SALES
SUM. RCOST
SUM. DCOST          MULTILINES AS 'Totals'
ON FILLER2 RECOMPUTE
AVE. SALES          MULTILINES AS 'Average'
ON BLANK3 SUBFOOT
""
""
"                             Summary Detail                                                    "
ON BLANK2 SUBFOOT
"                             Average<+0>Cost<+0>-<+0>Standard<+0>Invoice<+0> &BLANK <TOT.CARCNT>"
"                             Average Cost - Standard Invoice                                   "
"                             Invoice Count of Invoicess Meeting the Standard                   "
"                             % of the Invoices Meeting the Standard                            "
"                             Count of Invoices that are over the Standard Cost                 "
"                             % of Invoices that are over the total cost of the product         "
""
"                             Total Invoice Cost of all disability invoices                     "
"                             Count of Invoices that are not total disability invoices          "
"                             % of total disability invoices                                    "
"                             Count of disability that so not meet standards                    "
"                             % of partial disability invoices                                  "
""
"                             Average cost of all invoices including disability invoices        "
"                             Average count of all invoices                                     "
"                             % of average disability invoices                                  "
"                             Count invoices that are not disability                            "
"                             % of invoices that are not disability                             "
""
"                             Count of invoices that were not approved                          "
""
ON BLANK1A SUBFOOT
""
ON BLANK1 SUBFOOT
""
""
""
"                             Footnote "
ON BLANK SUBFOOT
""
"                             Calculation 1 "
"                             Calculation 2"
"                             Standard and non-standard invoices are separated according to the company`s standard policy procedure "
"                             Calculation 3"
"                             Calculation 4"
"                             Calculation 5"
"                             Calculation 6"
"                             Calculation 7"
""
ON FILLER3 SUBFOOT
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=OFF,
     ORIENTATION=LANDSCAPE,
$

TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,$


-*TYPE=SUBFOOT, HEADALIGN=BODY, JUSTIFY=LEFT,$
TYPE=SUBFOOT,BY=5,LINE=1,ITEM=6,JUSTIFY=RIGHT,POSITION=SALES2,COLOR=RED,$



-* Turns borders on, gets rid of the extra bottom border line
-* Turns the right and left borders off for the blank line that appears after the last bottom border
-* Gets rid of the grid lines for the blank line that appears after the last bottom border
TYPE=SUBFOOT,BORDER=ON,BACKCOLOR=RGB(237 241 213),$
TYPE=SUBFOOT,BY=1,BORDER-BOTTOM=ON,BORDER-BOTTOM-COLOR=WHITE,BORDER-TOP-COLOR=BLACK,COLSPAN=5,$
TYPE=SUBFOOT,BY=1,BORDER-RIGHT=OFF,BORDER-LEFT=OFF,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=3,BORDER-LEFT=OFF,BACKCOLOR=WHITE,$

-* Sets Colspan to 5
-* Gets rid of any unnecessary borders
TYPE=SUBFOOT,BY=2,COLSPAN=5,$
TYPE=SUBFOOT,BY=3,BORDER-BOTTOM=OFF,$
TYPE=SUBFOOT,BY=4,COLSPAN=5,BORDER-RIGHT=OFF,BORDER-LEFT=OFF,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=5,COLSPAN=5,$


-* Gets rid of the borders and grid lines on the blank lines that appear before the Summary Detail section
TYPE=SUBFOOT,BY=6,BORDER=OFF,BACKCOLOR=WHITE,$

-* Gets rid of the borders and grid lines on the blank lines that appear before the Footnote section
TYPE=SUBFOOT,BY=3,BORDER-RIGHT=OFF,BACKCOLOR=WHITE,$


-* Makes the word "Footnote" BOLD
TYPE=SUBFOOT,BY=3,LINE=4,OBJECT=TEXT,SIZE=10,STYLE=BOLD,$

-* Makes words "Summary Detail" BOLD
TYPE=SUBFOOT,BY=6,LINE=3,OBJECT=TEXT,SIZE=10,STYLE=BOLD,$
ENDSTYLE
END
 

This message has been edited. Last edited by: <Kathryn Henning>,

It may help.
Positioning datas within a CELL in EXCEL