Focal Point
[CLOSED] Active Report (AHTML) Column Width

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

March 25, 2019, 02:50 PM
TexasStingray
[CLOSED] Active Report (AHTML) Column Width
Anyone using 8204 with active reports (AHTML). I cannot get the columns to wrap at a specific width. It seems to always squeeze them. Works perfect in 8008 now migrating to 8204.

This message has been edited. Last edited by: FP Mod Chuck,




Scott

Scott

I created a new ahtml report under 8204 and it appears to work. Here is the syntax.


TABLE FILE WF_RETAIL
SUM
WF_RETAIL.WF_RETAIL_SALES.COGS_US
WF_RETAIL.WF_RETAIL_SALES.REVENUE_US
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE=REPORT,
LINES-PER-PAGE=20,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=0.500000,
$
ENDSTYLE
END



Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
Is WRAP possible in InfoAssist for XLXS?




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
Doug

Not in InfoAssist only with App Studio.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
I'm back... Something is missing...
The following code should show different column widths for columns FLD1 thru FLD5, should it? Does it for you? It doesn't for me. Those columns are all the same width, even if I set them to 1.0 thru 5.0 and other variations. This DOES work as expected in HTML but NOT in AHTML.

Please let me know your results, showing what was done to get it to work.

CODE
APP PREPENDPATH RETAIL_SAMPLES
DEFINE FILE WF_RETAIL
FLD1/A54 = 'A A A A A A A A A A A A A A A A A A A A A A A A A A A';
FLD2/A54 = 'B B B B B B B B B B B B B B B B B B B B B B B B B B B';
FLD3/A54 = 'C C C C C C C C C C C C C C C C C C C C C C C C C C C';
FLD4/A54 = 'D D D D D D D D D D D D D D D D D D D D D D D D D D D';
FLD5/A54 = 'E E E E E E E E E E E E E E E E E E E E E E E E E E E';
END
TABLE FILE WF_RETAIL
SUM
WF_RETAIL.WF_RETAIL_SALES.COGS_US
WF_RETAIL.WF_RETAIL_SALES.REVENUE_US
FLD1 FLD2 FLD3 FLD4 FLD5
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,$
UNITS=IN, GRID=OFF, BORDER=LIGHT, $
TYPE=REPORT,LINES-PER-PAGE=20, FONT=COURIER,$
TYPE=REPORT, COLUMN=N1, WRAP=0.100000, $
TYPE=REPORT, COLUMN=N2, WRAP=0.400000, $
TYPE=REPORT, COLUMN=N3, WRAP=0.600000, $
TYPE=REPORT, COLUMN=N4, WRAP=0.700000, $
TYPE=REPORT, COLUMN=N5, WRAP=1.000000, $
TYPE=REPORT, COLUMN=N6, WRAP=1.05000, $
TYPE=REPORT, COLUMN=N7, WRAP=1.200000, $
TYPE=REPORT, COLUMN=N8, WRAP=1.300000, $
TYPE=REPORT, COLUMN=N9, WRAP=2.400000, $
ENDSTYLE
END
-EXIT





   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
Work as expected
DEFINE FILE WF_RETAIL
FLD1/A54 = 'A A A A A A A A A A A A A A A A A A A A A A A A A A A';
FLD2/A54 = 'B B B B B B B B B B B B B B B B B B B B B B B B B B B';
FLD3/A54 = 'C C C C C C C C C C C C C C C C C C C C C C C C C C C';
FLD4/A54 = 'D D D D D D D D D D D D D D D D D D D D D D D D D D D';
FLD5/A54 = 'E E E E E E E E E E E E E E E E E E E E E E E E E E E';
END
TABLE FILE WF_RETAIL
SUM
WF_RETAIL.WF_RETAIL_SALES.COGS_US
WF_RETAIL.WF_RETAIL_SALES.REVENUE_US
FLD1 FLD2 FLD3 FLD4 FLD5
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,$
UNITS=IN, GRID=OFF, BORDER=LIGHT, $
TYPE=REPORT,LINES-PER-PAGE=20, FONT=COURIER,SQUEEZE=ON, $
TYPE=DATA, COLUMN=N1, WRAP=0.100000, $
TYPE=DATA, COLUMN=N2, WRAP=0.400000, $
TYPE=DATA, COLUMN=N3, WRAP=0.600000, $
TYPE=DATA, COLUMN=N4, WRAP=0.700000, $
TYPE=DATA, COLUMN=N5, WRAP=1.000000, $
TYPE=DATA, COLUMN=N6, WRAP=1.05000, $
TYPE=DATA, COLUMN=N7, WRAP=1.200000, $
TYPE=DATA, COLUMN=N8, WRAP=1.300000, $
TYPE=DATA, COLUMN=N9, WRAP=2.400000, $
ENDSTYLE
END
-EXIT



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007