I need the two bordered sections in the sample report to start at position 27. Pasted below is code using the Car File. Thanks.

  
SUM
RCOST
DCOST
FILLER AS ''
FILLER AS ''



DEFINE FILE CAR
BLANK/A1 WITH CAR  = ' ';
BLANK1/A1 = ' ';
BLANK2/A1 = ' ';
BLANK3/A1 = ' ';
FILLER/A1 = ' ';
END
TABLE FILE CAR
HEADING
"Testing Border in Subfoot  "
" "
" "
SUM
RCOST
DCOST
FILLER AS ''
FILLER AS ''

BY FILLER NOPRINT
BY BLANK  NOPRINT
BY BLANK1 NOPRINT
BY BLANK2 NOPRINT
BY BLANK3 NOPRINT
BY COUNTRY
ON BLANK3 SUBFOOT
"111"
"111"
"                             Summary Detail                                                    "
ON BLANK2 SUBFOOT
"                             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 BLANK1 SUBFOOT
"222"
"222"
"222"
"                             Footnote "
ON BLANK SUBFOOT
""
"                             Calculation 1 "
"                             Calculation 2"
"                             Standard and non-standard invoices are separated according the the company`s standard policy procedure "
"                             Calculation 3"
"                             Calculation 4"
"                             Calculation 5"
"                             Calculation 6"
"                             Calculation 7"
""
-*ON FILLER SUBFOOT
-*"333"
ON TABLE SET PAGE-NUM OFF
-*ON TABLE SET EMPTYCELLS OFF
ON TABLE NOTOTAL
ON TABLE SET SHOWBLANKS ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
-*TYPE=GRANDTOTAL,STYLE=BOLD,BORDER-TOP=MEDIUM,BORDER-TOP-COLOR=RGB(31 46 110),$
-*TYPE=SUBTOTAL,BORDER-RIGHT=0.20,$
-*TYPE=SUBTOTAL,BORDER-LEFT=0.20,$


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

-* Gets rid of the grid lines in the Subfoot
TYPE=SUBFOOT,BACKCOLOR=WHITE,COLSPAN=5,$

-* Top Border line after "Summary Detail"
TYPE=SUBFOOT,
     BORDER-BOTTOM=MEDIUM,
     BORDER-BOTTOM-COLOR='BLACK',
  COLSPAN=5,
$

-* Bottom Border line of the "Summary Detail" section
TYPE=SUBFOOT,
     BY=3,
     BORDER-BOTTOM=MEDIUM,
     BORDER-BOTTOM-COLOR='RED',
  COLSPAN=5,
$

-* Left Border
TYPE=SUBFOOT,
     BORDER-LEFT=MEDIUM,
     BORDER-LEFT-COLOR='GREEN',
$

-* Right Border
TYPE=SUBFOOT,
     BORDER-RIGHT=MEDIUM,
     BORDER-RIGHT-COLOR='BLUE',
$

-* Removes the right border from the blank lines that appear right before "Summary Detail"
TYPE=SUBFOOT,
     BY=5,
  BORDER-RIGHT=OFF,
$

-* Removes the right border from the blank lines that appear right after the "Footnote" section and extends the bottom border 5 columns
TYPE=SUBFOOT,
     BY=1,
  BORDER-RIGHT=OFF,
     BORDER-BOTTOM=MEDIUM,
     BORDER-BOTTOM-COLOR='ORANGE',
  COLSPAN=5,
$

-* Removes the right border from the blank lines that appear right before "Footnote"
TYPE=SUBFOOT,
     BY=3,
  BORDER-RIGHT=OFF,
  BACKCOLOR=WHITE,
$

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

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

This message has been edited. Last edited by: Michele Brooks,

You could set up an Excel template with the styling or create a macro to append a blank column before the first report column.

I've used Excel templates but never included a macro, there is documentation here: http://www.informationbuilders...rt/developers/macros

The report already runs using a macro template which I am not allowed to modify. I'll just have to see if the report can remain as is. Thanks.