Focal Point
Suppress HEADING on First Page

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8251008331

September 30, 2004, 03:11 PM
<mhuber>
Suppress HEADING on First Page
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>,
September 30, 2004, 04:02 PM
Steve C
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>,
September 30, 2004, 07:03 PM
<mhuber>
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?
September 30, 2004, 09:21 PM
<Prarie>
Do you want the heading to print on Page 2 and the rest of the pages...just no heading on page 1?
October 01, 2004, 02:25 PM
<mhuber>
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.
October 01, 2004, 04:59 PM
Noreen Redden
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
February 07, 2007, 06:17 PM
cspowell
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?
February 08, 2007, 07:03 AM
FrankDutch
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

February 08, 2007, 09:48 AM
cspowell
Not sure I see how this is different. What part of this suppresses the header space at the top of the page?
February 08, 2007, 10:08 AM
Francis Mariani
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
February 08, 2007, 10:09 AM
FrankDutch
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