Can someone please help me with the following formatting issue ?

I am generating a phone-directory layout report using the PAGEMATRIX sytyle-sheet option to allocate 6 columns for each report page.

Things are all lining up fine, but I am getting this extra space-line after each Name-Phone number entry on each of those 6 columns like this...

Name
City..Phone
(a blank line) <<<---- should not happen
Name
City..Phone
(a blank line) <<<---- should not happen

I have not coded for any such blank lines in my pgm below. Please review and advise how I can eliminate these blank lines and have the new Name-line come right below the previous City-Phone line. Considering the amount of data to be displayed and printed consistantly, eliminating these space lines will go a long way in saving some trees.

  
-* PAGEMATRIX=(cols rows)    for number of cols and rows of labels on a page
-* ELEMENT=(width height)    for width and height of each label
-* GUTTER=(horz vert)        for horz and vert distance b/w each label
-* MATRIXORDER={VERTICAL | HORIZONTAL}  sets order in which lables are printed
-* LABELPROMPT={OFF | ON }  sets the position of the first label on sheet
-*
TABLE FILE HOLD2
PRINT PROV_NAME AS ''
 OVER CTY_PHN AS ''
-*
BY STATE NOPRINT
BY COUNTY NOPRINT
BY SPCL NOPRINT
BY PROV_NAME NOPRINT
-*
ON STATE SUBHEAD
"<STATEX"
ON COUNTY SUBHEAD
"<COUNTY"
ON SPCL SUBHEAD
"<SPCL"
-*
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
    UNITS=IN, PAGESIZE=LETTER,
     LEFTMARGIN=0.3,SQUEEZE=ON,WRAP=OFF,
     TOPMARGIN=0.3,RIGHTMARGIN=0.2,
     PAGEMATRIX=(6 60),
        ELEMENT=(1.3 0.14) GUTTER=(0 0),$
TYPE=SUBHEAD,BY=B1,FONT='TAHOMA',SIZE=9,STYLE=BOLD,JUSTIFY=CENTER,$
TYPE=SUBHEAD,BY=B2,FONT='ARIAL',SIZE=8,STYLE=BOLD,JUSTIFY=CENTER,$
TYPE=SUBHEAD,BY=B3,FONT='ARIAL',SIZE=8,STYLE=BOLD+UNDERLINE,JUSTIFY=LEFT,WRAP=1.2,$
TYPE=REPORT,FONT='ARIAL',SIZE=6,GRID=OFF,LEFTGAP=0.05,RIGHTGAP=0.05,$
TYPE=DATA,COLUMN=P1,FONT='ARIAL',SIZE=7,STYLE=BOLD,$
-*
ENDSTYLE
END

Thank you all so much like always.
Best regards,
Sandeep Mamidenna

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

And for those of you who have not heard about this PAGEMATRIX option, check out the comment-lines at the top of my code above.

It took some digging to find this feature that easily lets you span across the page when you have a need for such Phone-Directory or New-Paper layout reports.

Sandeep Mamidenna

Sandeep,

Change your

ON TABLE SET PAGE-NUM NOPAGE

to read

ON TABLE SET PAGE-NUM NOLEAD

and you should get rid of the extra spaces.

However, PAGEMATRIX is used for printing a matrix of labels. Your code has it printing 6 columns containing 60 labels each of which are 1.3" by 0.14".

Cheers

Stu