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 MamidennaThis message has been edited. Last edited by: BlueZone,
------------------------------------------------------------------------------------------------- Blue Cross & Blue Shield of MS WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !!
July 16, 2008, 12:16 PM
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
------------------------------------------------------------------------------------------------- Blue Cross & Blue Shield of MS WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !!
July 17, 2008, 02:00 AM
StuBouyer
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".