April 15, 2008, 02:27 PM
JOEFormat issues
Hello,
My report's column totals skips a space and is on the next line after the word Total. I tried to fix this in painter but was unsucessful. Code below:
TABLE FILE DUMP
PRINT
FULLNAME/A75 AS 'FSC Name'
TIME AS 'START'
STIME AS 'STOP'
DTIME AS 'SCHEDULED'
COMPUTE SIGN/D5.1% = ( SIGNED_IN / SCHEDULED ) * 100; AS 'SIGN IN %'
COMPUTE COMPPER/D5.1% = ( COMPLIANCE / SCHEDULED ) * 100;
AS 'COMPLIANCE %'
BY TOTAL HIGHEST COMPUTE COMPPER/D5.1% = ( COMPLIANCE / SCHEDULED ) * 100; NOPRINT
ON TABLE SUBHEAD
"Adherence Report"
" "
"<TEAMNAME "
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE COMPPER AS 'TOTAL'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=ITALIC,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=DATA,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BACKCOLOR='WHITE',
$
TYPE=DATA,
COLUMN=N2,
FOCEXEC=v1adhere_datetest(Name=N2 dte=&dte.QUOTEDSTRING edte=&edte.QUOTEDSTRING),
$
TYPE=DATA,
COLUMN=ROWTOTAL(1),
STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
COLOR='WHITE',
BACKCOLOR='BLACK',
STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(1),
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
COLOR='WHITE',
STYLE=BOLD+ITALIC,
$
TYPE=TABHEADING,
SIZE=16,
STYLE=BOLD+ITALIC,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD+ITALIC,
$
TYPE=HEADING,
SIZE=16,
STYLE=BOLD+ITALIC,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD+ITALIC,
$
TYPE=SUBTOTAL,
STYLE=BOLD+ITALIC,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
COLOR='WHITE',
BACKCOLOR='BLACK',
STYLE=ITALIC,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(1),
BACKCOLOR='WHITE',
STYLE=BOLD+ITALIC,
$
TYPE=ACROSSTITLE,
COLOR='WHITE',
BACKCOLOR='BLACK',
STYLE=BOLD+ITALIC,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=ACROSSTITLE,
ACROSS=1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
STYLE=BOLD+ITALIC,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=GRANDTOTAL,
COLOR='WHITE',
BACKCOLOR='BLACK',
STYLE=BOLD+ITALIC,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
ENDSTYLE
END
Thanks for any assistance
April 15, 2008, 02:36 PM
Darin LeeThis has been addressed numerous times on the forum. The problem is that the first column is not wide enough for the complete text of your Total line label. Another issue is that you are trying to summarize a column (COMPPER) that you have NOPRINTed.
April 15, 2008, 02:38 PM
Francis Mariani"column totals skips a space and is on the next line after the word Total" - that's nothing new.
There are many posts about this behaviour.
Despite strong efforts, I have never seen a definitive solution to this problem.
I'm sure someone better will help you out.
Cheers,
April 15, 2008, 03:04 PM
JOECOMPR is a field (last field on report) I just NOPRINTED this field again at the beginning for sorting reasons. Anyways I figured it out and what I did was make fullname a by field as well. This seemed to do the trick.
Thanks,
Joe