Hi guys. I know this has probably been beat to death but I cant seem to understand or find what I need from previous posts.

Problem: I have a report that calculates the hours an employee worked per project and a total, as well as some qualifications earned based on those totals. In my subfoot I am trying to display the total hours and the qualifications earned, aligned with a particular column in the report per employee.

Basically I want TOTHOURS to show under the Hours,Dist column, nothing under the percent salary,then HOURSNEEDF to print under the "$1500" column, HOURSNEEDT under the '$2000', and so on.

I tried using the <+N to specify how many columns to put between the items in the subfoot but it is just not working and I couldnt figure out how to use the stylesheet.

Code:

DEFINE FILE TOTDATA
HOURSNEEDF/I4 = LOGIC OMITED
HOURSNEEDT/I4 = LOGIC OMITED
HOURSNEEDTF = LOGIC OMITED
CURRELIG/A4 = LOGIC OMITED
BLANK/A1 = ' ';
END
-RUN

TABLE FILE TOTDATA
PRINT CONTRACT_ABBREVIATION AS 'Proj,Abbrv'
PROJECT_STATUS AS 'Proj,Status'
APROJSTATEFDTE AS 'Proj,Status,Eff,Date'
PROJPERFENDDATE AS 'Proj,End Date'
DISTTHRUDATE AS 'Hours,Dist,Through'
PROJHOURS AS 'Hours,Dist'
PERSAL AS 'Percent,Salary'
BLANK AS '$1500'
BLANK AS '$2000'
BLANK AS '$2500'
BLANK AS 'Currently Eligible For:'
BY EMPLOYEE_NAME AS 'Emp.,Name'
BY UT_EID AS 'UT,EID'
BY EMPLOYEE_STATUS AS 'Emp.,Stat.'
BY AEMPSTATEFFDATE AS 'Emp.,Stat. Eff.,Date'
ON EMPLOYEE_NAME SUBFOOT
"<+10> < TOTHOURS <+1> < HOURSNEEDF < HOURSNEEDT < HOURSNEEDTF < CURRELIG"

Thanks!

Subfoots don't work well at all in excel
USING THE CAR FILE
TABLE FILE CAR
SUM SALES DEALER_COST
COMPUTE PCT/D7.3 = ( DEALER_COST / SALES ) * 100;
BY COUNTRY
BY MODEL
ON COUNTRY SUBTOTAL DEALER_COST SALES
ON TABLE PCHOLD FORMAT EXL2K
END

Will give subtotals on just two columns. Might try something like that.

You should be able to use HEADALIGN=BODY to align subfoot elements to the body of the report.

Here's a simple example:

TABLE FILE CAR
SUM SALES
CNT.MODEL NOPRINT
BY COUNTRY
ON COUNTRY
SUBFOOT
"TOTAL MODELS <CNT.MODEL"
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=SUBFOOT, HEADALIGN=BODY, $
TYPE=SUBFOOT, ITEM=2, JUSTIFY=RIGHT, COLOR=RED, $
ENDSTYLE
END