Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Suppress HEADING on First Page
Go
New
Search
Notify
Tools
Reply
  
Suppress HEADING on First Page
 Login/Join
 
<mhuber>
posted
I need to suppress the header on the first page of output. Basically, I want to do:


TABLE FILE CAR
PRINT SEATS
BY COUNTRY PAGE-BREAK NOPRINT
BY MODEL
ON COUNTRY SUBHEAD
"Country: HEADING
"This is a page heading"
WHEN TABPAGENO NE 1;
ON TABLE SET ONLINE-FMT PDF
END


...but it chokes on the WHEN. Is there a SET Parameter or something that will take care of what I need?

Thanks,
Michael

This message has been edited. Last edited by: <Mabel>,
 
Reply With QuoteReport This Post
Silver Member
posted Hide Post
Try This:



TABLE FILE CAR
PRINT SEATS
TABPAGENO NOPRINT
BY COUNTRY PAGE-BREAK NOPRINT
BY MODEL
ON COUNTRY SUBHEAD
"Country: HEADING
"This is a page heading"
-*WHEN TABPAGENO NE 1;
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET STYLE *
TYPE=HEADING,COLOR=WHITE,
WHEN=TABPAGENO EQ 1,
$
ENDSTYLE
END

The trick is to put the TABPAGENO into the body of the request so the style sheet can evaluate it.

This message has been edited. Last edited by: <Mabel>,
 
Posts: 44 | Location: New York City | Registered: May 23, 2004Reply With QuoteReport This Post
<mhuber>
posted
Not exactly what I'm looking for...
I've done a few work-arounds (including that one), but I'd really like to suppress the heading completely. It seems like a pretty basic reporting function, so I'm guessing there would be a simple, straightforward solution.

Any thoughts?
 
Reply With QuoteReport This Post
<Prarie>
posted
Do you want the heading to print on Page 2 and the rest of the pages...just no heading on page 1?
 
Reply With QuoteReport This Post
<mhuber>
posted
Yes.
We're using ON TABLE SUBHEAD to display a different report heading on the first page. We want the HEADING to appear on the second & all subsequent pages.

Thanks.
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
You can't use WHEN with HEADING, only with ON stuff, like ON COUNTRY SUBHEAD ... WHEN
Can you live with the line being blank on the first page?
TABLE FILE CAR
... COMPUTE HEADER/A80 = IF TABPAGENO EQ 1 THEN ' ' ELSE 'THIS IS THE HEADER'; NOPRINT
...
HEADING
"<HEADER"
END
 
Posts: 60 | Location: 2 penn | Registered: May 22, 2003Reply With QuoteReport This Post
Member
posted Hide Post
Found this post and Noreen's technique worked great. BUT, I have a followup question:

I am wanting to supress the heading on every page except the first (a report with page breaks and repaging, so there are many page 1s). I was able to successfully do that, but is there any way to get rid of the page heading space on the subsequent pages? It still holds that big block of space at the top of the page. How can I get rid of it?
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Colin

this works by me....

TABLE FILE CAR
PRINT
     CAR
     MODEL
     BODYTYPE
     SALES
BY COUNTRY NOPRINT

ON COUNTRY SUBTOTAL AS 'TOTAL'
ON COUNTRY PAGE-BREAK REPAGE
ON TABLE SUBHEAD
"This is the report heading"
HEADING
"<COUNTRY "
FOOTING
"&DATEtrMDYY <+10> <TABPAGENO"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF



or is this not what you want?

Frank




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Not sure I see how this is different. What part of this suppresses the header space at the top of the page?
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
If you want a heading on only the first page, have you tried

ON TABLE SUBHEAD
"..."

To suppress the reserved space above the heading on each page, try

SET PAGE=NOLEAD


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by cspowell:
Not sure I see how this is different. What part of this suppresses the header space at the top of the page?


If I run this I get the report heading text only on the first page en the next pages do not have a report space heading
but maybe you have to do that in the settings part like

ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     LEFTMARGIN=0.194444,
     RIGHTMARGIN=0.000000,
     TOPMARGIN=0.097222,
     BOTTOMMARGIN=0.000000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     PAGECOLOR=RGB(172 192 233), 




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Suppress HEADING on First Page

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.