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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to remove space between subheads/subfoots in PDF ?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] How to remove space between subheads/subfoots in PDF ?
 Login/Join
 
Silver Member
posted
Hi everybody,
I have encountered the following issue:
I have a report that has some data but I have to print the heading + subheads/subfoots based on some conditions. The problem is that I can't remove the blank space that is left in the report even when there is PRINT SOME_FIELD NOPRINT. One idea was to SUM on the some fields that correspond to the longest sequence of columns that are used but that works only if
all other subheads/subfoots are printed based on some of these columns ( those of the previous subfoot/subhead ). I've tryied SET EMPTYREPORT = ON|ANSI but this is not the case ... There is a post from mcgrakin where he suggests that setting TOPGAP = 0.000 and BOTTOMGAP = 0.000 and SIZE = 1 in report's data style but there are some tiny spaces left as well. So my question is whether there is way to achieve this without ANY spaces at all between the subheads and subfoots ? Thanks in advance.

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


WF 7.6.5 / OS: XP / FOCUS
 
Posts: 42 | Registered: September 01, 2008Report This Post
Virtuoso
posted Hide Post
Try setting PRINTPLUS=ON and see if it helps.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Silver Member
posted Hide Post
Nope ... Frowner


WF 7.6.5 / OS: XP / FOCUS
 
Posts: 42 | Registered: September 01, 2008Report This Post
Virtuoso
posted Hide Post
See if this produces any ideas -here
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Unless you do something wacky, I think your only option is the SIZE=1.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
Have you tried conditional subheads/subfoots?
  
TABLE FILE CAR
PRINT 
     COUNTRY
     CAR 
     MODEL
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT

ON CAR SUBHEAD
"Subhead <COUNTRY"
WHEN (COUNTRY EQ 'ENGLAND') AND
     (CAR EQ 'JENSEN');
ON CAR SUBFOOT
"Subfoot <COUNTRY"
WHEN (COUNTRY EQ 'ITALY') OR 
     (COUNTRY EQ 'FRANCE');
END 

-EXIT


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
 
Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008Report This Post
Silver Member
posted Hide Post
Exactly this causes the problem with spaces ... I've managed a workaround by multiplying the rows of the table by the number of subfoots and subheads treating them as column by somehow adjusting the corresponding positions which runs very slow though ...


WF 7.6.5 / OS: XP / FOCUS
 
Posts: 42 | Registered: September 01, 2008Report This Post
<JG>
posted
If I read it correctly you only want heading subheads and subfoots

Here is a basic method as a starter

 
SET PAGE=NOLEAD
TABLE FILE CAR
"Heading"
SUM
COMPUTE DUMMY/A4='NULL'; AS '' 
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT

ON CAR SUBHEAD
"Subhead <COUNTRY> "
WHEN (COUNTRY EQ 'ENGLAND') AND
     (CAR EQ 'JENSEN');
ON CAR SUBFOOT
"Subfoot <COUNTRY> "
WHEN (COUNTRY EQ 'ITALY') OR 
     (COUNTRY EQ 'FRANCE');
ON TABLE HOLD AS WP FORMAT WP NOCC
END 
-RUN
FILEDEF MAS DISK WP.MAS
-RUN
-WRITE MAS  FILENAME=WP      , SUFFIX=FIX     , $
-WRITE MAS  SEGMENT=WP, SEGTYPE=S0, $
-WRITE MAS  FIELDNAME=f1, USAGE=A2, ACTUAL=A02, $
-WRITE MAS  FIELDNAME=C1, USAGE=A8, ACTUAL=A08, $
-WRITE MAS  FIELDNAME=C2, USAGE=A12, ACTUAL=A12, $
-WRITE MAS  FIELDNAME=f2, USAGE=A1, ACTUAL=A56, $
TABLE FILE WP
PRINT C1  
      C2  
WHERE C1 OMITS 'NULL'
ON TABLE HOLD FORMAT ALPHA
END
-RUN
TABLE FILE HOLD 
PRINT C1 AS '' 
      C2 AS ''
ON TABLE PCHOLD FORMAT PDF
END

 
Report This Post
Silver Member
posted Hide Post
I thought about format WP but I didn't know how to make it work - great many thanks ! Thanks all as well for the support.


WF 7.6.5 / OS: XP / FOCUS
 
Posts: 42 | Registered: September 01, 2008Report This Post
<JG>
posted
Most important thing is that the master that you create has the correct total length of columns.

By default FORMAT WP is an LRECL of 80.

If you are having any problems then stick ?FILEDEF after the HOLD FORMAT WP and you will
see what LRECL you actually have.
 
Report 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     [SOLVED] How to remove space between subheads/subfoots in PDF ?

Copyright © 1996-2020 Information Builders