I have searched the forum and have come across quite a few threads regarding this problem, but no matter what I try, I cannot get this to work. I have a column title with a really long name so the column width in Excel ends up being really wide (whether I put the commas in the title name to wrap it or not). I cannot get WRAP or SQUEEZE to work in the style sheet (whether I put the commas in the title or not). Please help. This is so frustrating. Below, I put the scenario in the CAR file.
Thanks so much,
Krysti
TABLE FILE CAR PRINT COUNTRY MODEL CAR AS 'A REALLY, REALLY LONG, COLUMN NAME' ON TABLE SET PAGE-NUM OFF ON TABLE PCHOLD FORMAT EXL2K ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, LEFTMARGIN=0.150000, RIGHTMARGIN=0.000000, TOPMARGIN=0.500000, BOTTOMMARGIN=0.000000, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, FONT='ARIAL', SIZE=9, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, RIGHTGAP=0.125000, TOPGAP=0.013889, BOTTOMGAP=0.027778, $ TYPE=TITLE, COLUMN=N1, WRAP=.25, $ TYPE=DATA, COLUMN=N1, WRAP=.25, $ TYPE=TITLE, COLUMN=N2, WRAP=.25, $ TYPE=DATA, COLUMN=N2, WRAP=.25, $ TYPE=TITLE, COLUMN=N3, WRAP=.25, $ TYPE=DATA, COLUMN=N3, WRAP=.25, $ ENDSTYLE ENDThis message has been edited. Last edited by: Kerry,
WF 767
January 20, 2009, 05:10 PM
Francis Mariani
Try TYPE=REPORT:
-* File fmfp001.fex
TABLE FILE CAR
PRINT
COUNTRY
MODEL
CAR AS 'A REALLY, REALLY LONG, COLUMN NAME'
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.150000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.000000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=.25,
$
ENDSTYLE
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
January 20, 2009, 05:15 PM
Francis Mariani
Look for "Controlling Column Width and Wrapping in Excel 2000" in the "Creating Reports With WebFOCUS Language" document.
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
January 20, 2009, 05:16 PM
Darin Lee
I do not believe that the WRAP or SQUEEZE syntax can be transferred to Excel, as column width is a function that is specifically managed by Excel. You could try using an Excel template or seeing if the -HTMLFORMTYPE (referenced in several postings) would afford you any added functionality. Try a search on those and see if you can find any additional useful information.
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
January 20, 2009, 05:25 PM
Darin Lee
Yup. There you go. I don't use EXL2K as much so not that familiar with its use. Should have noticed, hewever, that you should be using TYPE=REPORT instead of TITLE or DATA.This message has been edited. Last edited by: Darin Lee,
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
January 20, 2009, 06:01 PM
GinnyJakes
Krysti,
Please put your release in your signature. There were issues with this very thing in the early versions of 7.6.x that were fixed by 7.6.2. If you are running 7.6.1, I can get you a case number to reference.
Darin is also correct in that TYPE=REPORT is the preferred syntax.
TYPE=REPORT worked! Thank you so much. I had read everything I could find regarding this issue and never realized that was the correct syntax.
I really appreciate all your replies!
Krysti
WF 767
January 21, 2009, 10:28 AM
Francis Mariani
quote:
Darin is also correct in that TYPE=REPORT is the preferred syntax.
- so is Francis.
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
January 26, 2009, 04:17 PM
RCourtemanche
quote:
Originally posted by GinnyJakes: Krysti,
Please put your release in your signature. There were issues with this very thing in the early versions of 7.6.x that were fixed by 7.6.2. If you are running 7.6.1, I can get you a case number to reference.
Darin is also correct in that TYPE=REPORT is the preferred syntax.
Can we get that case number? We're converting to WF 7.6.1 and are running into this WRAP issue with a large text field that we output to PDF. Seems to wrap, but not the full width of the page like it does in WF 5 that we're coming from.
Originally posted by Francis Mariani: Try TYPE=REPORT:
-* File fmfp001.fex
TABLE FILE CAR
PRINT
COUNTRY
MODEL
CAR AS 'A REALLY, REALLY LONG, COLUMN NAME'
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.150000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.000000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=.25,
$
ENDSTYLE
END
woo hoo! This also solved my problem! I've got a report that's not very wide, and my logo at the top-left was colliding with my header. By using TYPE=REPORT,COLUMN=N1,WRAP=X I was able to stretch my report out so the logo would fit!