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, MichaelThis 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