Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]Stretch column
Go
New
Search
Notify
Tools
Reply
  
[Solved]Stretch column
 Login/Join
 
Platinum Member
posted
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,


WebFocus 7.7.02 WinXP
 
Posts: 236 | Registered: May 12, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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,


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Read this article it tells you about the difference in Styling HTML and PDF.

here
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
That article by Mickey is valuable information.
Smiler
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Article very valuable..Thanks!


WebFocus 7.7.02 WinXP
 
Posts: 236 | Registered: May 12, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]Stretch column

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.