I am using the following to right justify the column title and data. It works for numeric columns but not for alphanumeric. Am I missing something?

TYPE=DATA,
COLUMN=N3,
JUSTIFY=RIGHT,
$

TYPE=TITLE,
COLUMN=N3,
JUSTIFY=RIGHT,
$

This message has been edited. Last edited by: Kerry,

JUSTIFY=RIGHT works fine.

Are you sure it is COLUMN=N3 the one you need to change the alignment to?

When using N notation for columns, *every* field involved in your request counts, even BY fields and those with NOPRINT.

Just to test, can you try using the P notation instead?

So if it is the 3rd column printed in your report the one you want to change, you could do:

TYPE=DATA, COLUMN=P3, JUSTIFY=RIGHT, $
TYPE=TITLE, COLUMN=P3, JUSTIFY=RIGHT, $

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.

Regards,
Neftali.

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,

Do you have ACROSS columns and is the output PDF? If so, column justification is problematic. This post concerns a similar situation.

Data alignment in PDF

Try TYPE=REPORT instead of TYPE=DATA:

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

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,

$
TYPE=DATA,
COLUMN=N5,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N4,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N3,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N2,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N15,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N14,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N13,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N12,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N11,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N10,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N9,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N7,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N16,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N8,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N5,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N4,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N2,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N6,
JUSTIFY=RIGHT,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
STYLE=BOLD+UNDERLINE,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

Seems to work for me:

TABLE FILE CENTHR
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=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,

$
TYPE=DATA,
COLUMN=N5,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N4,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N3,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N2,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N15,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N14,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N13,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N12,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N11,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N10,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N9,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N7,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N16,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N8,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N5,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N4,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N2,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N6,
JUSTIFY=RIGHT,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
STYLE=BOLD+UNDERLINE,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

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

"It is a known issue that currently column justification is now working correctly"

Bad typo!