 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] wrap in a stylesheet | Login/Join |
| Master |
I have created a little fex to try to wrap the MODEL field, which would allow me to the narrow the width of the DEALER_COST AS 'D' and RETAIL_COSTAS 'R' fields which I want to display beneath it. Anyone have any ideas? Here is the code: [ -* -* A LESSON ON STYLESHEETS -* TABLE FILE CAR DEALER_COST/D2 AS 'D' RETAIL_COST/D2 AS 'R' SALES/I2 AS 'S ' BY COUNTRY BY CAR ACROSS MODEL ON TABLE SET PAGE NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, GRID=ON, FONT='TIMES NEW ROMAN', SIZE=10, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, $ TYPE=REPORT, COLUMN=N0, SQUEEZE=0.250000, $ ENDSTYLE END ] Thanks!  This message has been edited. Last edited by: Kerry, Tomsweb WebFOCUS 8.1.05M, 8.2.x APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports Apache Tomcat/8.0.36 | ||
|
| Platinum Member |
Try changing "SQUEEZE" to "WRAP" and converting the numeric fields to alphanumeric formats. John WF 7.7.03, Windows 7, HTML, Excel, PDF | |||
|
| Expert |
John right,as far as I am aware you cannot wrap a numeric. Should you be minimising th size of you numbers, say 2000 as 2K etc. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
Per John's suggestion, I have changed "SQUEEZE" to "WRAP" and converted the numeric fields to alphanumeric formats. I still cannot get the model field to wrap.  Here is the code: [ TABLE FILE CAR DEALER_COST/D7 NOPRINT COMPUTE ALPHA_D/A14 = FTOA(DEALER_COST, '(D7)', ALPHA_D); AS 'D' -* RETAIL_COST/D7 AS 'R' NOPRINT COMPUTE ALPHA_R/A14 = FTOA(RETAIL_COST, '(D7)', ALPHA_D); AS 'R' -* SALES/I6 NOPRINT COMPUTE SALES_F/F6 = SALES; NOPRINT COMPUTE ALPHA_S/A14 = FTOA(SALES_F, '(F6)', ALPHA_S); AS 'S' -* COMPUTE ZLPHA_S/A16 = '"' || ALPHA_S || '"'; AS 'Z' BY COUNTRY BY CAR ACROSS MODEL ON TABLE SET PAGE NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, GRID=ON, FONT='TIMES NEW ROMAN', SIZE=10, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, $ TYPE=REPORT, COLUMN=N0, WRAP=0.250000, $ ENDSTYLE END -RUN -* -EXIT ] Tomsweb WebFOCUS 8.1.05M, 8.2.x APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports Apache Tomcat/8.0.36 | |||
|
| Virtuoso |
A couple of things - since the column you are wanting to shrink is an ACROSS column, you are not using the correct keyword in your stylesheet - it would have to be ACROSSVALUE - TYPE=ACROSSVALUE, ACROSS=MODEL, COLOR=RED, WRAP=0.5,$ . That being said, I don't think you can do what you are trying to do in PDF or EXL2K format. It will only work for HTML. Sounds weird, I know but if you think about it, PDF must respect ALL spaces and column widths for fields so the width of the MODEL column would have to be controlled by the combined width of all the columns within that ACROSS column. THAT being said, if you turn SQUEEZE=OFF (with HTMLCSS ON) in HTML format, the individual column widths are extended (not squeezed) but the column title IS wrapped appropriately. Hmmmm I would go ahead and open a case with tech support on this one 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 | |||
|
| Platinum Member |
Tom, Try removing the COLUMN=N0, declaration. Regards, John WF 7.7.03, Windows 7, HTML, Excel, PDF | |||
|
| Virtuoso |
The values for the ACROSS field are basically untouchables due to the way FOCUS handles them. I even tried using the LINEBREAK stylesheet command and it still does not make the ACROSS values WRAP. I have one more idea to test. It ain't pretty but it might be good enough to use. I will post some code as soon as I can. Thanks! Mickey
| |||||
|
| Virtuoso |
Mickey - the weird thing is that your statement is only true for PDF/EXL2K - wrap on across works fine in HTML. 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 | |||
|
| Virtuoso |
Darin, That's because HTML is a whole different animal. The very nature of the browser displaying HTML has the dynamic wrapping behavior builtin. This is core HTML behavior which ahs nothing to do with WebFOCUS. I talk about this in my first article about HTML and PDF Report Design. The following is an ugly solution to the issue at hand. DEFINE FILE CAR NEWMODEL/A24=PARAG(24, MODEL, ';', 8, NEWMODEL); MODELP1/A8=GETTOK(NEWMODEL, 24, 1, ';', 8, MODELP1); MODELP2/A8=GETTOK(NEWMODEL, 24, 2, ';', 8, MODELP2); MODELP3/A8=GETTOK(NEWMODEL, 24, 3, ';', 8, MODELP3); END TABLE FILE CAR SUM RCOST ACROSS MODEL NOPRINT ACROSS MODELP1 AS 'MODEL' ACROSS MODELP2 AS '' ACROSS MODELP3 AS '' BY COUNTRY BY CAR WHERE COUNTRY EQ 'W GERMANY' ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * TYPE=REPORT, ORIENTATION=LANDSCAPE, SQUEEZE=ON, WRAP=0.75,$ ENDSTYLE END Thanks! Mickey
| |||||
|
| Virtuoso |
Here's a better looking version: DEFINE FILE CAR NEWMODEL/A24=PARAG(24, MODEL, ';', 8, NEWMODEL); MODELP1/A8=GETTOK(NEWMODEL, 24, 1, ';', 8, MODELP1); MODELP2/A8=GETTOK(NEWMODEL, 24, 2, ';', 8, MODELP2); MODELP3/A8=GETTOK(NEWMODEL, 24, 3, ';', 8, MODELP3); END TABLE FILE CAR SUM RCOST ACROSS MODEL NOPRINT ACROSS MODELP1 AS 'MODEL' ACROSS MODELP2 AS '' ACROSS MODELP3 AS '' BY COUNTRY BY CAR WHERE COUNTRY EQ 'W GERMANY' ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * TYPE=REPORT, ORIENTATION=LANDSCAPE, FONT='ARIAL', SQUEEZE=ON, WRAP=0.75,$ TYPE=REPORT, COLUMN=COUNTRY, WRAP=1.00,$ TYPE=ACROSSVALUE, ACROSS=MODELP1, COLOR=RED, BORDER-LEFT=MEDIUM,BORDER-RIGHT=MEDIUM,BORDER-TOP=MEDIUM,$ TYPE=ACROSSVALUE, ACROSS=MODELP2, COLOR=RED, BORDER-LEFT=MEDIUM,BORDER-RIGHT=MEDIUM,$ TYPE=ACROSSVALUE, ACROSS=MODELP3, COLOR=RED, BORDER-LEFT=MEDIUM,BORDER-RIGHT=MEDIUM,$ TYPE=ACROSSTITLE, ACROSS=MODELP1, BACKCOLOR=NAVY, COLOR=WHITE,$ TYPE=TITLE, BORDER=MEDIUM, BACKCOLOR=NAVY, COLOR=WHITE,$ TYPE=DATA , BORDER=MEDIUM,$ ENDSTYLE END Thanks! Mickey
| |||||
|
| Master |
mgrackin AND others Thanks very much :> ! Tomsweb WebFOCUS 8.1.05M, 8.2.x APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports Apache Tomcat/8.0.36 | |||
|
| Member |
Thanks for the post. This saved the day today. | |||
|
| Gold member |
mgrackin, Thanks for the work-around method. it is messy, but it works. Thanks! WebFOCUS 8.2.01 AppStudio HTML, PDF, Excel | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |