Is there a way to get Precision Reports to precisely align fields within a Subfooting but outside of the Data Matrix (directly on the Canvas layer)? The idea is to have multiple employee names on one page with data precisely aligned for each employee.

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

I need more information please. Where are you using the subfooting, i.e. is it in the Data Matrix? The only place I have found you can show 'multiple' values is inside the data matrix. What is your sort break / page break field for this report?

I would be interested in seeing a snapshot of the form that you are working on.

Kathy,

I was not able to get a screen print of the report to post.

Here is the code.

It would be most helpful if the fields in the subfoot could be aligned directly on the canvas rather than within the Data Matrix.

It has been extremely time consuming tedious work trying to align fields within the Data Matrix - this method requires the use of a non-proportional spaced font (like courier new) where each character is the exact same width; and spot markers must also be used to get the fields properly aligned (using the old-school method).

Please advise if there is a way to use the precision report tool (new-school method) to align individual repeating fields on the canvas without displaying the Data Matrix itself. The idea here is to populate a certified payroll form with about 5 or 6 employees per page.

Many thanks,

DAD
TABLE FILE CERT_BIWK
PRINT
SPACER_05 NOPRINT
BY PROJECT_SPLIT NOPRINT
BY NAME NOPRINT
BY SS# NOPRINT

ON SS# SUBFOOT
"<NAME <27 D <28 <DT_DAY_01 <-1 <DT_DAY_02 <-1 <DT_DAY_03 <-1 <DT_DAY_04 <-1 <DT_DAY_05 <-1 <DT_DAY_06 <-1 <DT_DAY_07"
"<SSN_4DIGIT <27 ________________________________________<28 <DT_DAY_08 <-1 <DT_DAY_09 <-1 <DT_DAY_10 <-1 <DT_DAY_11 <-1 <DT_DAY_12 <-1 <DT_DAY_13 <-1 <DT_DAY_14"
" <27 O <28 <OT_DAY_01 <-1 <OT_DAY_02 <-1 <OT_DAY_03 <-1 <OT_DAY_04 <-1 <OT_DAY_05 <-1 <OT_DAY_06 <-1 <OT_DAY_07 "
"<JOB_FUNCTION_NAME <27 ________________________________________<28 <OT_DAY_08 <-1 <OT_DAY_09 <-1 <OT_DAY_10 <-1 <OT_DAY_11 <-1 <OT_DAY_12 <-1 <OT_DAY_13 <-1 <OT_DAY_14 "
" <27 S <28 <RT_DAY_01 <-1 <RT_DAY_02 <-1 <RT_DAY_03 <-1 <RT_DAY_04 <-1 <RT_DAY_05 <-1 <RT_DAY_06 <-1 <RT_DAY_07 "
"WITHHOLDING EXEMPTION <-4 <NUM_OF_WH <27 ________________________________________<28 <RT_DAY_08 <-1 <RT_DAY_09 <-1 <RT_DAY_10 <-1 <RT_DAY_11 <-1 <RT_DAY_12 <-1 <RT_DAY_13 <-1 <RT_DAY_14 "
" <66 <HRSTOT <81 <FRINGE <91 <PAYTOT <101 <GROSS <109 <FED <117 <FICA <124 <STATE <132 <SDI <140 <OTHER "
ON SS# NOSPLIT
HEADING
"HOURS WORKED EACH DAY"
"WORK CLASSIFICATION"
"<DAY_01"
"<DAY_02 "
"<DAY_03 "
"<DAY_04 "
"<DAY_05 "
"<DAY_07 "
"<DAY_08 "
"<DAY_09 "
"<DAY_10 "
"<DAY_11 "
"<DAY_12 "
"<DAY_13 "
"<DAY_14 "
"PRIME CONTRACTOR <+0> "
"<CPNY_NAME "
" <DAY_01_LABEL "
" <DAY_02_LABEL "
" <DAY_03_LABEL "
" <DAY_04_LABEL "
" <DAY_05_LABEL "
" <DAY_06_LABEL "
" <DAY_07_LABEL "
"<DAY_06 "
"EMPLOYEE NAME"
"LAST 4 DIGITS OF SSN"
"WITHHOLDING EXEMPTIONS"
" "
"PROJECT AND LOCATION"
"<PROJECT_NAME <LOCATION_NAME "
"PROJECT NO. OR CONTRACT NO."
"<CONTRACT_NAME "
"<USM_STREET_ADDR <USM_STREET_ADDR_2 "
"<USM_CITY_DESC <-1>, <USM_STATE_ABBR <USM_ZIP_PLUS4 "
"PROJECT PAYROLL NO. <PROJ_PAYNO "
"FOR PERIOD ENDING: <END_DATE"
"TOTAL HOURS"
"RATE OF PAY"
"GROSS AMOUNT EARNED THIS PROJECT"
"GROSS AMOUNT EARNED ALL PROJECTS"
"TOTAL FRINGE"
"FEDERAL TAX"
FOOTING
"Page <TABPAGENO of <TABLASTPAGE "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET NEWLAYOUT ON
ON TABLE SET COMPOSITION DEFAULT
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='COURIER NEW',
SIZE=8,
NAME=Page,
METADATA='>GUIDE>show=1,snap=1,<GUIDE<>GRID>show=1,snap=1,sizex=4,sizey=4,<GRID<>RULER>show=1,<RULER<',
$

-***************************************
-* hundreds of lines of deleted styling
-* would normally be here but have been
-* removed for this posting
-***************************************

TYPE=HEADING,
OBJECT=Box,
POSITION=(6.250000 1.013889),
DIMENSION=(0.625000 6.916667),
NAME=BOX9,
PARENT=Heading,
BORDER-TOP=1,
BORDER-BOTTOM=1,
BORDER-LEFT=1,
BORDER-RIGHT=1,
METADATA='anchor=0,parentanchor=0,flags=1,line=0,item=0',
$
TYPE=HEADING,
OBJECT=Line,
POSITION=(0.013889 1.930556),
ENDPOINT=(10.930556 1.930556),
NAME=LINE1,
PARENT=Heading,
BORDER-TOP=1,
METADATA='anchor=0,parentanchor=0,flags=1,line=0,item=0',
$
TYPE=DATAMATRIX,
NAME=Data Matrix,
POSITION=(0.166667 1.916667),
DIMENSION=(12.500000 6.250000),
METADATA='focusverb=,flags=1>DB>anchor=0,parentanchor=0,flags=11,line=0,item=0<DB<',
$
ENDSTYLE
END

You can say POSITION=fieldname on a sufoot object to align it with a column in the report.
I think this would solve your problem.

The trick to use the heading section and insert the text separately and the field separately, all under heading section. Then you can use the tool bar at the bottom to align up your text and then to align up your fields. If you create a heading and put in the text and your fields into one heading, it's almost impossible to align. I'm not sure you can do multiple records outside the matrix. The heading section is just like a heading.

Has anyone saved an Excel compound report out to a specific location without using FTP? Thank you Pat

PRonan,

Best to post this on its own thread as it is completely unrelated to this topic. You'll also find that this has been covered several times if you use the Search function.

Solved
FILEDEF COMPFILE DISK C:\TEMP\COMPFILE.XLS
-RUN
TABLE FILE CAR
HEADING
"ONE"
SUM SALES ACROSS COUNTRY
ON TABLE HOLD AS COMPFILE FORMAT EXL2K OPEN
END
TABLE FILE CAR
HEADING
"TWO"
PRINT MPG BY COUNTRY
ON TABLE HOLD AS COMPFILE FORMAT EXL2K
END
TABLE FILE CAR
HEADING
"FIVE"
PRINT CAR BY COUNTRY
ON TABLE HOLD AS COMPFILE FORMAT EXL2K CLOSE
END

Thank you very much everyone life is wonderful!