Not sure if I'm explaining this right or not. I have a report which as several columns. I need the first column stretched to the max value and not wrap. No matter what I set studio developer to..it keeps wrapping even by setting column to max...I'm stumped.

 ENGINE SQLMSS SET DEFAULT_CONNECTION IVB
SQL SQLMSS
EX ORBIT.dbo.AHTReport '&dte','&edte'
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END
TABLE FILE SQLOUT
SUM
     stafftime
     calls
     acdtime
     acwtime
     holdacdtime
     stafftime
     aux0
     aux1
     aux2
     aux3
     aux4
     aux5
     aux6
     aux7
     aux8
BY EmpGroupName
BY EmpDivisionName
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS AHTGRP FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     RIGHTGAP=0.125000,
	 ORIENTATION=LANDSCAPE,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END
TABLE FILE AHTGRP
PRINT
     calls/I11C AS 'Calls Answered,'
     COMPUTE AVGTalk/I3 = IF calls EQ 0 THEN 0 ELSE acdtime / calls;
     COMPUTE AVGACW/I3 = IF calls EQ 0 THEN 0 ELSE acwtime / calls;
     COMPUTE AVGHold/I3 = IF calls EQ 0 THEN 0 ELSE holdacdtime / calls;
     COMPUTE AHT/I3 = IF calls EQ 0 THEN 0 ELSE ( acdtime + acwtime + holdacdtime ) / calls;
     COMPUTE AUX/D6.2% = IF stafftime EQ 0 THEN 0 ELSE ( aux0 + aux1 + aux2 + aux3 + aux4 + aux5 + aux6 + aux7 + aux8 ) / stafftime * 100;
     COMPUTE AUX0/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux0 / stafftime * 100;
     COMPUTE AUX1/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux1 / stafftime * 100;
     COMPUTE AUX2/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux2 / stafftime * 100;
     COMPUTE AUX3/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux3 / stafftime * 100;
     COMPUTE AUX4/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux4 / stafftime * 100;
     COMPUTE AUX5/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux5 / stafftime * 100;
     COMPUTE AUX6/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux6 / stafftime * 100;
     COMPUTE AUX7/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux7 / stafftime * 100;
     COMPUTE AUX8/D6.2% = IF stafftime EQ 0 THEN 0 ELSE aux8 / stafftime * 100;
BY EmpGroupName AS 'Group                   '
HEADING
"&DIV<+0>'s AHT Report"
"Between <+0>&dte<+0> and <+0>&edte"
" "
FOOTING
""
WHERE EmpDivisionName EQ '&DIV';
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE AHTGRP.SEG01.calls AVGTalk AVGACW AVGHold AHT AUX AUX0 AUX1 AUX2 AUX3 AUX4 AUX5 AUX6 AUX7 AUX8 AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,
     RIGHTGAP=0.125000,
     JUSTIFY=LEFT,
	 ORIENTATION=LANDSCAPE,
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N1,
     FOCEXEC=aht/teamaht(Grp=N1 dte=&dte.QUOTEDSTRING edte=&edte.QUOTEDSTRING),
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR='BLUE',
     BORDER-BOTTOM-COLOR='BLUE',
     BORDER-LEFT-COLOR='BLUE',
     BORDER-RIGHT-COLOR='BLUE',
     BACKCOLOR=RGB(255 102 0),
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     BORDER-TOP-COLOR='BLUE',
     BORDER-BOTTOM-COLOR='BLUE',
     BORDER-LEFT-COLOR='BLUE',
     BORDER-RIGHT-COLOR='BLUE',
     SIZE=12,
     COLOR='WHITE',
     BACKCOLOR='BLUE',
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='VERDANA',
     SIZE=14,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     FONT='VERDANA',
     SIZE=14,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     FONT='VERDANA',
     SIZE=9,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=2,
     FONT='VERDANA',
     SIZE=9,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=3,
     FONT='VERDANA',
     SIZE=9,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=4,
     FONT='VERDANA',
     SIZE=9,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     COLOR='WHITE',
     BACKCOLOR='GRAY',
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N3,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N4,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N5,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N6,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N7,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N8,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N9,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N10,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N11,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N12,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N13,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N14,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N15,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N16,
     SQUEEZE=OFF,
$
TYPE=REPORT,
     COLUMN=N2,
     SQUEEZE=OFF,
$
ENDSTYLE
END 

Thanks for any help possible

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

Couple questions....

1.You have three procedures listed here(ON TABLE HOLD AS SQLOUT, ON TABLE HOLD AS AHTGRP, ON TABLE PCHOLD ) Which "first column" are you trying to stop the wrapping on?

2. Just a cosmetic thing, but why do you issue
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END
And then turn around and requery the exact same table? I dont see the purpose here.

3.I see a lot of repeating STYLE commands. Is there a reason for that?

4. I see you have SQUEEZE=OFF on all your TYPE lines except here:
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,

Read this article it tells you about the difference in Styling HTML and PDF.

here

quote:

Originally posted by Prarie:
Read this article it tells you about the difference in Styling HTML and PDF.

here

Wow, I learned something new. Thanks for that, Prarie. So, the GRID=OFF will turn off word wrapping.

One other item - if you're so concerned about column-width, word wrapping, and preserving spaces, then you might want to switch to PDF output instead of just using HTML. HTML does a lot of things (such as compressing blank spaces and column-widths, word wrapping, etc.) by default that you may not want.

That article by Mickey is valuable information.

Article very valuable..Thanks!