Hi,

Iam trying to align columns in my report.Since i print column names and values using subhead and headings Iam facing my alignment issues in my report(pdf format).


The below code is nearly aligned.But column2 and column8 does not align with their respective values.I tried to use POSITION=1.5 or 3 etcc that is mentioning the values, iwas able to align it somewhat but the justification did not work.

Every time my column becomes wider or longer i need to keep changing the position as well.Is there any other way that i can do this ?
I donot want to increase the width as well.

 
TABLE FILE CAR
BY COUNTRY NOPRINT

ON COUNTRY SUBHEAD
"<COUNTRY<BODYTYPE<DEALER_COST<SALES"
"<CAR<SEATS<RETAIL_COST<LENGTH<HEIGHT"
HEADING
"POSITION EXAMPLE"
"Column1<+0>Column2<+0>Column3<+0>Column4<+0>"
"Column7<+0>Column8<+0>Column9<+0>Column10<+0>"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
$

TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='ARIAL',
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=2,
     ITEM=1,
     POSITION='N1',
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=2,
     ITEM=2,
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=2,
     ITEM=3,
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=2,
     ITEM=4,
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='ARIAL',
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=3,
     ITEM=1,
     POSITION='N1',
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=3,
     ITEM=2,
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=3,
     ITEM=3,
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=3,
     ITEM=4,
     WRAP=1.000000,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=1,
     ITEM=1,
     WRAP=2.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000000,
     COLOR=RED,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=1,
     ITEM=2,
     WRAP=1.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=1,
     ITEM=3,
     WRAP=1.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=1,
     ITEM=4,
     WRAP=1.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=2,
     ITEM=1,
     WRAP=1.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=2,
     ITEM=2,
     WRAP=1.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=2,
     ITEM=3,
     WRAP=1.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=2,
     ITEM=4,
     WRAP=1.000000,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
ENDSTYLE
END

 

Appreciate your help!

Thanks!

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

POSITION is used to position the heading object to a report column, of which there are none in this example.

WRAP should do the trick:

TABLE FILE CAR
BY COUNTRY NOPRINT

ON COUNTRY SUBHEAD
" "
HEADING
"POSITION EXAMPLE"
"COLUMN1<+0>COLUMN2<+0>COLUMN3<+0>COLUMN4"
"COLUMN7<+0>COLUMN8<+0>COLUMN9<+0>COLUMN10"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
UNITS=IN,SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,FONT='ARIAL', SIZE=9, $
TYPE=HEADING, LINE=2, ITEM=1, WRAP=1, COLOR=RED, $
TYPE=HEADING, LINE=2, ITEM=2, WRAP=1, COLOR=BLUE, $
TYPE=HEADING, LINE=2, ITEM=3, WRAP=1, COLOR=YELLOW, $
TYPE=HEADING, LINE=2, ITEM=4, WRAP=1, COLOR=GREEN, $
TYPE=HEADING, LINE=3, ITEM=1, WRAP=1, COLOR=RED, $
TYPE=HEADING, LINE=3, ITEM=2, WRAP=1, COLOR=BLUE, $
TYPE=HEADING, LINE=3, ITEM=3, WRAP=1, COLOR=YELLOW, $
TYPE=HEADING, LINE=3, ITEM=4, WRAP=1, COLOR=GREEN, $
ENDSTYLE
END

Hi,

Sorry , i have edited the code in teh first post by using the CODE tag.Did not about the usage of it .

I have not used position ,the only reason being need to know some other method. although iam using wrap, the last line W GERMANY does not wrap instead it displays as W alone. I do not want increase the width like i said in the first post.

Appreciate you help.

Thanks!
Janani

Your code works perfectly OK on 7.6.7

 
POSITION EXAMPLE
COLUMN1   COLUMN2 COLUMN3 COLUMN4
COLUMN7   COLUMN8 COLUMN9 COLUMN10
ENGLAND   HARDTOP 37,853  12000
TRIUMPH   13      45,319  741       205
FRANCE    SEDAN   4,631   0
PEUGEOT   5       5,610   182       57
ITALY     COUPE   41,235  30200
MASERATI  10      51,065  687       203
JAPAN     SEDAN   5,512   78030
TOYOTA    8       6,478   328       108
W GERMANY SEDAN   54,563  88190
BMW       34      64,732  1,309     392
 

The only change I made was to add

TYPE=SUBHEAD, SIZE=10,$

If you have a fixed width then the only way you can fit more into it is to make what
you put in smaller