[SOLVED]Getting WRAP or SQUEEZE to work with active reports
I have an report with a wide alphanumeric column. Upon converting to an Active Report, the style sheet WRAP and SQUEEZE properties have no effect. How can I get either of these properties to work with Active Report enabled?
Thank you,
JohnThis message has been edited. Last edited by: <Emily McAllister>,
WF 7.7.03, Windows 7, HTML, Excel, PDF
July 02, 2008, 03:49 AM
arvind
hi john,
Does active report mean AHTML format???? Because i had a hard time wrapping the long Alphanumeric columns in PDF Format.
WebFOCUS 714 Windows XP Output: HTML,PDF,Excel
July 02, 2008, 05:25 AM
Danny-SRL
Did you try:
-* File Wrap.fex
TABLE FILE CAR
PRINT MODEL MODEL MODEL
BY COUNTRY BY CAR
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=OFF, ORIENTATION=PORTRAIT, GRID=ON, size=9, $
TYPE=REPORT, COLUMN=N3, WRAP=1.00, $
TYPE=REPORT, COLUMN=N4, WRAP=0.7, $
TYPE=REPORT, COLUMN=N5, WRAP=0.5, $
ENDSTYLE
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
July 02, 2008, 08:48 AM
mgrackin
John,
I was asked this question during my presentation at Summit. Was that you? The question was whether or not Active Reports supports WRAP and SQUEEZE settings. Since I do not have a license for AHTML I never have tried this. I assumed it would but it looks like I was wrong. Unfortunately I can't do testing to see how to get around this.
Does anyone else have an Active Reports license to test this?
Thanks!
Mickey
FOCUS/WebFOCUS 1990 - 2011
July 02, 2008, 09:18 PM
JohnB
Danny,
I tried your suggestion, but it had no effect.
Thank you,
John
WF 7.7.03, Windows 7, HTML, Excel, PDF
July 02, 2008, 09:45 PM
Tom Flynn
JohnB,
Make sure your HEADINGS are not longer than the report columns; that will stretch out the columns...
Create a new column and SUBSTR/EDIT the original.
Make sure "NOT" to use a AnV column, change it to An...
Make sure SQUEEZE=ON
Tom
EDIT:
Heres some code, try it and notice that the HEADING does to the columns. Now split the HEADING into 2 lines and the columns condense. We had this problem with images...
DEFINE FILE CAR
X_COST/P13.2M = DEALER_COST;
Y_COST/P13.2M = RETAIL_COST;
DESC/A50 = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA';
END
TABLE FILE CAR
HEADING
"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
SUM
X_COST NOPRINT
Y_COST NOPRINT
BY COUNTRY AS ''
SUM
DEALER_COST/P13.2M
RETAIL_COST/P13.2M
DESC
BY COUNTRY PAGE-BREAK
BY CAR
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=OFF,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=10,
$
TYPE=TITLE,
STYLE=BOLD,
$
ENDSTYLE
END
-EXIT
This message has been edited. Last edited by: Tom Flynn,
After running some tests and looking at the (very complicated) HTML source produced by the HOLD FORMAT AHTML, I think that there are 2 conclusions: 1. The output being HTML, the WRAP attribute is ignored (not so in PDF, Arvind). 2. The HTML+Javascript generated by WF causes the columns to not wrap even if the output page is wider than your screen.
So, if you are intent on having the possibility to manage the column width of your Active Reports, you should put in a NFR.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
July 07, 2008, 11:53 AM
JohnB
Tom,
I believe Daniel is correct.
John
WF 7.7.03, Windows 7, HTML, Excel, PDF
May 12, 2016, 11:30 AM
J.Hines
I know this is a really old post, but it still came up early in the results for me. The solution I found is that you have to change the TYPE for AHTML reports.
In other words, this works for Excel:
TYPE=REPORT, COLUMN=N5, WRAP=4, $
But in AHTML, to get it to wrap, you have to use TYPE=DATA:
TYPE=DATA, COLUMN=N5, WRAP=4, $
It's silly that this is the way it is, since it's completely non-intuitive, but it's a workaround.