Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Un-Intended Space-lines in report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Un-Intended Space-lines in report
 Login/Join
 
Platinum Member
posted
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,


-------------------------------------------------------------------------------------------------
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 !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
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 !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
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


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Un-Intended Space-lines in report

Copyright © 1996-2020 Information Builders