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

This 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.

"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,

COMPR 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