Focal Point
EXL2K and SQUEEZE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3871009331

October 17, 2005, 05:54 PM
Francis Mariani
EXL2K and SQUEEZE
Why is it that the width of the columns in an Excel spreadsheet generated by format EXL2K does not correspond to the data within?

I have to use TYPE=REPORT, COLUMN=x, SQUEEZE=n to change the width of the columns even though I have TYPE=REPORT, SQUEEZE=ON.

And, according to the manual, SQUEEZE=n is supposed to be used for PDF and PS only, but it works for EXL2K.

Thank you.
October 17, 2005, 09:47 PM
Francis Mariani
Additionally, something weird (a bug) occurs when using the SQUEEZE command in conjunction with the SEQUENCE command.

TABLE FILE CAR
PRINT SALES
BY COUNTRY
BY MODEL
ON TABLE SET ONLINE-FMT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=MODEL, SEQUENCE=1, $
TYPE=REPORT, COLUMN=COUNTRY, SQUEEZE=6.0, COLOR=BLUE, $
ENDSTYLE
END

The column size change does not happen to COUNTRY, but to MODEL.
October 18, 2005, 04:03 AM
susannah
Pfrancis, what's the SEQUENCE command? never seen that one before.
Oh..i see..i looked it up. hmmm. that could be useful...glad you brought it up.
sorry its giving you probs;
October 18, 2005, 02:45 PM
Francis Mariani
Susannah, one example of the SEQUENCE command being really handy is if you want to make the row total the first column.

PS. "Pfrancis", are you being sly or was that a typo?! Smiler )
December 07, 2005, 02:58 PM
Prarie
Is there something special you need to make this work? I'm trying to control columns in
EXL2K and it is just plain ignoring me and not changing.
According to the documentation it should work for EXL2k as well. I'm using 5.3.4
Am I missing something?
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='LEGAL',
ORIENTATION=LANDSCAPE,$
TYPE=REPORT,
SQUEEZE=ON,
GRID=ON,$
TYPE=REPORT,COLUMN=DIFF_PD ,SQUEEZE=7.5,$
TYPE=REPORT,COLUMN=DIFF_1 ,SQUEEZE=7.5,$
TYPE=REPORT,COLUMN=CW_A_DELV_CPG ,SQUEEZE=7.5,$
TYPE=REPORT,COLUMN=DIFF_PD_DE ,SQUEEZE=7.5,$
ENDSTYLE
END


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 07, 2005, 03:21 PM
mgrackin
I do not see anywhere in the documentation that this is supported for EXL2K. Can you post where you see this in the documentation?


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
December 07, 2005, 06:04 PM
Mikel
WRAP and SQUEEZE are supported for EXL2K hold format.

IBI Doc.Ref.:
Controlling Column Width and Wrapping in Excel 2000

The following example works fine (WF 7.1):

TABLE FILE CAR
  SUM 
    SALES
  BY COUNTRY
  BY CAR
  BY MODEL
  ON TABLE PCHOLD FORMAT EXL2K
  ON TABLE SET STYLE *
    TYPE=REPORT, COLUMN=COUNTRY, SQUEEZE=2, $
    TYPE=REPORT, COLUMN=CAR, SQUEEZE=2, $
    TYPE=REPORT, COLUMN=MODEL, SQUEEZE=3, $
END


Regards,
Mikel


WebFOCUS 8.1.05, 8.2.01
December 07, 2005, 07:02 PM
susannah
sly



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 08, 2005, 11:45 AM
k.lane
Well, I've always used WRAP and have had no problems at all:

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=COUNTRY, WRAP=2, $
TYPE=REPORT, COLUMN=CAR, WRAP=1, $
TYPE=REPORT, COLUMN=MODEL, WRAP=1, $
END

WF 5.3.3

Ken


Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Databases: Oracle 10g, SQL Server 2000, DB2.
December 09, 2005, 11:51 AM
Prarie
Yes the documentation was for 7.1 after further investigation. Nope Wrap does not work either.
One problem was the columns were averaged. AVE.DIFF_PD AVE.DIFF_1 added that to the actual column name...did not work. The final problem seems to be, this is compound Excel...with the exact same columns in each sheet...just subtotaled different...and so squeezing or wrapping does not work. If I just run the first one, with WRAP and AVE. added to the stylesheet it works.
So guess it is the Compound Sheet.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 09, 2005, 02:55 PM
EvelynS
Yes, the column formatting options are ignored if you are using compound reports with the output to one worksheet. If you can split the output to different worksheets than you can use the column formatting. The limitation is due to the fact you cannot have different widths for a column in an Excel report and WEBFOCUS does not know that the formats being requested are all the same for a compound request so it ignores the code.
December 09, 2005, 03:09 PM
Prarie
Thanks for the confirmation.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 13, 2005, 10:12 AM
Francis Mariani
Actually, I'm having difficulty understanding EvelynS's reply.

"you cannot have different widths for a column in an Excel report" - I did not know that was true. Why, then, has K.Lane successfully used WRAP and Mikel successfully used SQUEEZE?

"WEBFOCUS does not know that the formats being requested are all the same for a compound request so it ignores the code" - why, then, are we allowed to code different style sheets for each report in a compound report?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 07, 2007, 02:15 PM
<Patch4Ever>
Francis
Has anybody responded to your question regarding Squeezing and Column Sizing? I am just now finishing up a compound excel report and would love to know what is working and what is not. Thanks for any additional information!
March 07, 2007, 02:28 PM
Francis Mariani
There has been no response, so I abandoned ship.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 07, 2007, 02:31 PM
<Patch4Ever>
That's not good. I will get back to you if I find anything once I start testing. Smiler
March 07, 2007, 02:45 PM
Dennis_V
Just wanted to jump in here and say that I was successful using WRAP to control Excel column widths in a compound Excel report.

It was just what I needed, when I needed it, so thanks to k.lane for the tip.

BTW: We are running 7.1.4

Dennis


Local: AppStudio 8.2.03 - Win7 - Tomcat Server: WebFOCUS 8.2.03 - Windows 2008 R2 Enterprise on VMWare 2 CPU, 3.2GHz, 4GB of RAM Output Formats: HTML, Excel, PDF, PPT, Active Reports
March 07, 2007, 05:58 PM
Francis Mariani
Squeezes, but mucks up the multi-line Column Title:

TABLE FILE CAR
SUM 
SALES AS 'THIS IS THE,SALES,COLUMN'
BY COUNTRY AS 'THIS IS THE,COUNTRY,COLUMN'
BY CAR AS 'THIS IS THE,CAR,COLUMN'
BY MODEL AS 'THIS IS THE,MODEL,COLUMN'
ON TABLE PCHOLD FORMAT EXL2K

ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=COUNTRY, SQUEEZE=1, $
TYPE=REPORT, COLUMN=SALES, SQUEEZE=1, $
TYPE=REPORT, COLUMN=CAR, SQUEEZE=1, $
TYPE=REPORT, COLUMN=MODEL, SQUEEZE=1, $
END

Works:

TABLE FILE CAR
SUM 
SALES AS 'THIS IS THE,SALES,COLUMN'
BY COUNTRY AS 'THIS IS THE,COUNTRY,COLUMN'
BY CAR AS 'THIS IS THE,CAR,COLUMN'
BY MODEL AS 'THIS IS THE,MODEL,COLUMN'
ON TABLE PCHOLD FORMAT EXL2K

ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=COUNTRY, WRAP=1, $
TYPE=REPORT, COLUMN=SALES, WRAP=1, $
TYPE=REPORT, COLUMN=CAR, WRAP=1, $
TYPE=REPORT, COLUMN=MODEL, WRAP=1, $
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 08, 2007, 03:59 PM
Carol Dobson
TYPE=REPORT, COLUMN=COUNTRY, SQUEEZE = .50,$

will work without mucking up the column totals.



WebFOCUS 7.6.6/TomCat/Win2k3