Hi
I am creating a report that uses a recap/subfoot. I have the details of the contract printed. Then under the details I have added a recap to do a variance calculation. I created the subfoot to display the recap. Here is my issue. The subfoot has about an inch of empty space between the last line of detail in the contract and the beginning of the subfoot. There is no space between the end of the subfoot and the beginning of the next contract. So it looks like the recap/subfoot from the first contract belongs to the data of the second contract below it. I have looked through a lot of the forum postings and can't find anything that addresses this. Not sure if this is a coding change in the subfoot or if it is a coding change in the overall style sheet. If anyone has any ideas, I would appreciate it!!
Thanks!
Tracey

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

Tracey...please update your signature on your profile with what version you are using. Also can you post the code so we get a better idea of what you are doing?

Hopefully I updated my profile correctly. Sorry bout that!! Here is the code!

TABLE FILE DW_SALES_ORDERS
PRINT
     'DW_SALES_ORDERS.DW_SALES_ORDERS.LINE_VALUE' AS 'Line,Value'
     'JOBS.JOBS.JOB_VALUE' AS 'Job Value'
BY 'DW_SALES_ORDERS.DW_SALES_ORDERS.CONTRACT_NUM' AS 'Contract'
BY 'JOBS.JOBS.JOB_VALUE' NOPRINT
BY 'DW_SALES_ORDERS.DW_SALES_ORDERS.SO_DESCRIPTION' AS 'Description'
BY 'DW_SALES_ORDERS.DW_SALES_ORDERS.JOB_NUMBER' AS 'Job'
BY 'DW_SALES_ORDERS.DW_SALES_ORDERS.SO_LINE_NO' AS 'Line'

ON DW_SALES_ORDERS.DW_SALES_ORDERS.CONTRACT_NUM SUBTOTAL
     LINE_VALUE MULTILINES AS 'Total for Contract '
ON DW_SALES_ORDERS.DW_SALES_ORDERS.CONTRACT_NUM RECAP
DIFFERENCE/D12.2 = DW_SALES_ORDERS.DW_SALES_ORDERS.LINE_VALUE - JOBS.JOBS.JOB_VALUE;
ON DW_SALES_ORDERS.DW_SALES_ORDERS.CONTRACT_NUM SUBFOOT WITHIN
"Difference between Sales Order Contract Value and Job Cost Value is <DIFFERENCE "
HEADING
"GENERAL DYNAMICS - OTS (<+0>&REPORT_ENTITY_TEXT<+0>)"
"Contract Value vs. Job Cost Value "
"Report Name: Contract vs. Job Value"
"Report Run <+0>&DATEtrMDYY <+0> at <CURRENT_TIME "
"Page <TABPAGENO of <TABLASTPAGE"
"**Displays contracts that have been statused as Data Entry Complete"
WHERE ( REPORT_ENTITY EQ '&REPORT_ENTITY.(FIND REPORT_ENTITY IN entities).REPORT_ENTITY.' );
WHERE PRIME_CONTRACT_NO NE 'B&|P' OR 'CAP' OR 'INV' OR 'IRAD' OR 'IRD';
WHERE ASSOC_PRIME_CONTRACT NE 'B&|P' OR 'CAP' OR 'INV' OR 'IRAD' OR 'IRD';
WHERE LINE_VALUE NE 0;
WHERE CUSTOMER_NAME NE ' ';
WHERE SO_STATUS_FLAG NE 'CANCELLED';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.000000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     RIGHTGAP=0.125000,
$
TYPE=DATA,
     SIZE=8,
     BACKCOLOR=( RGB(234 234 255) 'WHITE' ),
$
TYPE=DATA,
     COLUMN=N7,
     SIZE=7,
$
TYPE=DATA,
     COLUMN=N5,
     SIZE=7,
$
TYPE=DATA,
     COLUMN=N4,
     SIZE=7,
$
TYPE=DATA,
     COLUMN=N3,
     SIZE=7,
$
TYPE=DATA,
     COLUMN=N6,
     SIZE=7,
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N7,
     SIZE=8,
$
TYPE=TITLE,
     COLUMN=N5,
     SIZE=8,
$
TYPE=TITLE,
     COLUMN=N4,
     SIZE=8,
$
TYPE=TITLE,
     COLUMN=N3,
     SIZE=8,
$
TYPE=TITLE,
     COLUMN=N6,
     SIZE=8,
$
TYPE=TABHEADING,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=HEADING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=12,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     SIZE=14,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=11,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=11,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=11,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=11,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=10,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=9,
     COLOR='BLACK',
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=9,
     COLOR='BLACK',
$
TYPE=HEADING,
     LINE=2,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=9,
     COLOR='BLACK',
$
TYPE=HEADING,
     LINE=3,
     JUSTIFY=RIGHT,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=10,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=10,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=4,
     SIZE=9,
     COLOR='BLACK',
$
TYPE=HEADING,
     LINE=3,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=10,
$
TYPE=HEADING,
     LINE=4,
     JUSTIFY=RIGHT,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=9,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=9,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=4,
     SIZE=9,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=9,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=FIELD,
     ITEM=2,
     SIZE=9,
     COLOR='BLACK',
$
TYPE=HEADING,
     LINE=5,
     JUSTIFY=RIGHT,
$
TYPE=HEADING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
$
TYPE=HEADING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=9,
$
TYPE=HEADING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=9,
$
TYPE=HEADING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=4,
     SIZE=9,
$
TYPE=HEADING,
     LINE=5,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=9,
$
TYPE=HEADING,
     LINE=5,
     OBJECT=FIELD,
     ITEM=2,
     SIZE=9,
$
TYPE=HEADING,
     LINE=6,
     JUSTIFY=LEFT,
$
TYPE=HEADING,
     LINE=6,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
$
TYPE=FOOTING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     BY=1,
     LINE=1,
     JUSTIFY=RIGHT,
$
TYPE=SUBTOTAL,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BY=1,
     BACKCOLOR=RGB(204 255 204),
$
TYPE=ACROSSVALUE,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     COLUMN=ROWTOTAL(4),
     BACKCOLOR=RGB(234 234 255),
$
TYPE=ACROSSTITLE,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N4,
     SQUEEZE=0.305556,
$
TYPE=REPORT,
     COLUMN=N3,
     WRAP=3.430556,
$
TYPE=REPORT,
     COLUMN=N6,
     SQUEEZE=1.000000,
$
TYPE=REPORT,
     COLUMN=N2,
     SQUEEZE=0.500000,
$
ENDSTYLE
END

Try setting SET PRINTPLUS=ON

If that doesn't help. Take off the styling and see if that is causing the problem.

Do I need to add that line of coding anywhere particular within the report?

I added it to the beginning of my report. It removed all the extra lines...YEAH. Now how could I add a line or two after the subfoot just to break up the report a little?

Try adding a couple of
""
""
lines after the
SUBFOOT

If I add the "" after the subfoot, that just makes the subfoot bigger (especially since I a backgroung color applied to it). I want a couple blank lines between the end of the subfoot and then the beginning of the next contract.

Have you tried adding a SKIP-LINE on your by for the subfoot ? You can also set up a define for a blank line and the nprint that after your subfoot.

try adding a second line in the subfoot:
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
COMPUTE DIFF/D12M = RETAIL_COST - DEALER_COST; NOPRINT
BY COUNTRY

ON COUNTRY SUBFOOT
"The Cost difference between Retail and Dealer: " "
HEADING
"Head 1"
"Head 2"
FOOTING
""
ON TABLE SET PAGE-NUM OFF
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='ARIAL', SIZE=9, RIGHTGAP=0.125000,$
TYPE=HEADING, SIZE=12, STYLE=BOLD,$
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, SIZE=8,$
TYPE=SUBFOOT, SIZE=10, STYLE=BOLD,$
TYPE=SUBFOOT, BY=1, LINE=2, OBJECT=TEXT, BACKCOLOR=GRAY, SIZE=8,$
ENDSTYLE
END

WF 8 version 8.2.04. Windows.
In focus since 1990.

Add this to your stylesheet for your SubFoot.
TYPE=SUBFOOT,
LINE=1,
that way you are only doing all the styling on the first line. Then you can stick " " to skip a line.

sorry cut and paste error the first time.
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
COMPUTE DIFF/D12M = RETAIL_COST - DEALER_COST; NOPRINT
BY COUNTRY

ON COUNTRY SUBFOOT
"The Cost difference between Retail and Dealer: " "
HEADING
"Head 1"
"Head 2"
FOOTING
""
ON TABLE SET PAGE-NUM OFF
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='ARIAL',
SIZE=9,
RIGHTGAP=0.125000,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=TEXT,
SIZE=8,
BACKCOLOR='GRAY',
$
ENDSTYLE
END

WF 8 version 8.2.04. Windows.
In focus since 1990.