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.
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>,
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, 2004
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.
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.
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, 2003
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, 2005
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, 2006
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, 2006