The fact that it seems to work for numeric values may be that numbers are by default right-aligned so even if you were trying to style the wrong column you wouldn't notice the effect.
Yes, its the 3rh column. I made sure by also including COLOR=RED and the color of column data changes to red but the text is still left alligned. I also tried doing in GUI and using P3 instead but still didn't work. Also, I have the same problem with all alphanumeric columns in this report and not just the one I indicated. Not sure what's wrong. I will open a case with tech support. Thanks.This message has been edited. Last edited by: texgator,
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)
April 24, 2010, 11:47 AM
Dan Satchell
Do you have ACROSS columns and is the output PDF? If so, column justification is problematic. This post concerns a similar situation.
TABLE FILE CAR
PRINT
*
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,
FONT='ARIAL', SIZE=8, $
TYPE=REPORT, COLUMN=N2, COLOR=RED, JUSTIFY=RIGHT, $
ENDSTYLE
-*ON TABLE PCHOLD FORMAT EXL2K
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
April 26, 2010, 12:04 PM
texgator
The output is in AHTML and following is the styling code. Basically its just ignoring all the column justifications I am asking for and just putting them out as default i.e. numbers aligned right and alphanumeric aligned left. Any clues?
ON TABLE SET PAGE-NUM OFF ON TABLE COLUMN-TOTAL AS 'Total' 'GLTRANS.GLTRANS.PSLAMO' 'GLTRANS.GLTRANS.PSAMTR' ON TABLE PCHOLD FORMAT AHTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $ TYPE=DATA, COLUMN=N15, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N14, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N13, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N12, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N11, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N10, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N9, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N7, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N16, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N8, JUSTIFY=RIGHT,
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
April 26, 2010, 02:39 PM
texgator
Hmm..interesting. I think its an issue with my version 7.6.10. Below is the response I got from tech support. I tried the code below with HTML output and it works but when I switch to AHTML, it doesn't work. Too bad I need the reports in AHTML format to have sorting, export, and other functions that end users could do.
Tech Support response: "It is a known issue that currently column justification is now working correctly with active report output. I will associate your case with the known issue and you will be contacted with the release number where this issue is fixed."
TABLE FILE car PRINT * ON TABLE SET PAGE-NUM OFF ON TABLE COLUMN-TOTAL AS 'Total' ON TABLE PCHOLD FORMAT AHTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $ TYPE=DATA, COLUMN=N1, JUSTIFY=RIGHT, $ TYPE=TITLE, COLUMN=N1, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N2, JUSTIFY=RIGHT, $ TYPE=TITLE, COLUMN=N2, JUSTIFY=RIGHT, $ TYPE=DATA, COLUMN=N3, JUSTIFY=RIGHT, $ TYPE=TITLE, COLUMN=N3, JUSTIFY=RIGHT, $
ENDSTYLE END
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)
April 26, 2010, 02:50 PM
Francis Mariani
"It is a known issue that currently column justification is now working correctly"
Bad typo!
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