Hello,

Please run my code below to understand my requirement. I want to make some heading Lines disappear on the OVERFLOW pages. I tried in Composer and this is achieveable using Composer.

Is there any other way to get the same result not using components?

TABLE FILE CAR
PRINT
CAR
MODEL
BY SEATS PAGE-BREAK
HEADING
" "
" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"
" "
" "
" I WANT THIS LINE ONLY ON 1ST PAGE OF PAGE BREAK i.e 1,3,5"
" (NOT ON THE OVERFLOW PAGE. PAGES-2,4 & 6 ARE OVERFLOW PAGES)"
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
PAGESIZE='ENVELOPE-DL', LEFTMARGIN=0.5, RIGHTMARGIN=0.025, TOPMARGIN=0.1000,
BOTTOMMARGIN=0.4000, SQUEEZE=OFF, UNITS=IN, ORIENTATION=LANDSCAPE, TOPGAP=0.05, BOTTOMGAP=0.05,$
ENDSTYLE
END

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

If this is achievable using Composer, could you please post the code generated by Composer - the clue might be in there.

Does this help, use SUBHEAD:

TABLE FILE CAR
PRINT
CAR
MODEL
BY SEATS PAGE-BREAK
HEADING
" "
" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"
" "
" "

ON SEATS SUBHEAD
" I WANT THIS LINE ONLY ON 1ST PAGE OF PAGE BREAK i.e 1,3,5"
" (NOT ON THE OVERFLOW PAGE. PAGES-2,4 & 6 ARE OVERFLOW PAGES)"
" "

ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
PAGESIZE='ENVELOPE-DL', LEFTMARGIN=0.5, RIGHTMARGIN=0.025, TOPMARGIN=0.1000,
BOTTOMMARGIN=0.4000, SQUEEZE=OFF, UNITS=IN, ORIENTATION=LANDSCAPE, TOPGAP=0.05, BOTTOMGAP=0.05,$
ENDSTYLE
END

Francis,

The SUBHEAD appears only on the 1st page of the report. I want them to be on the pages 1,3 & 5.

-Hari
WF-769

The SUBHEAD indeed appears on pages 1, 3 and 5 because the SUBHEAD is for the SEATS column. I imagine, though, that you would like the SUBHEAD to appear above the column titles, not below - that is, if you require column titles.

Sorry for the confusion.
I typed in "ON TABLE SUBHEAD" and ran my report.

As per my requirements, i want the column titles and SUBHEADs above the titles.

In Composer, the syntax "DisplayOn=OVERFLOW-ONLY" makes the component to appear only on the overflow page.

" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"

Is this line ONLY an image, or is there also a text line? If it's only an image, we may be able to solve your problem.

The line has an image and a text line as well.

-Hari

This can be achieved only using Composer.

A rather crude method of doing this is -

TABLE FILE CAR
PRINT CAR
      MODEL
      COMPUTE OVERFLOW_PAGE/A1 = IF (TABPAGENO - (INT(TABPAGENO / 2) * 2)) EQ 1 THEN 'N' ELSE 'Y'; NOPRINT
   BY SEATS PAGE-BREAK
HEADING
" "
" I WANT THIS LINE IN ALL PAGES (SOME IMAGE AS PER THE REQUIREMENT)"
" "
" "
" I WANT THIS LINE ONLY ON 1ST PAGE OF PAGE BREAK i.e 1,3,5"
" (NOT ON THE OVERFLOW PAGE. PAGES-2,4 & 6 ARE OVERFLOW PAGES)"
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
PAGESIZE='ENVELOPE-DL', LEFTMARGIN=0.5, RIGHTMARGIN=0.025, TOPMARGIN=0.1000,
BOTTOMMARGIN=0.4000, SQUEEZE=OFF, UNITS=IN, ORIENTATION=LANDSCAPE, TOPGAP=0.05, BOTTOMGAP=0.05,$
TYPE=HEADING, LINE=5, COLOR=WHITE, WHEN=OVERFLOW_PAGE EQ 'Y', $
TYPE=HEADING, LINE=6, COLOR=WHITE, WHEN=OVERFLOW_PAGE EQ 'Y', $
ENDSTYLE
END

T

Thanks Tony. Your technique was great, works perfectly. I appreciate ur efforts.
However, with my real data, not all sort value breaks equally to two pages.

I was wondering if there would be any technique to capture the Page number based on the Page-Break.

-Hari

The old disappearing text trick... Turn it white on white... Sometimes...

Hmmm, this could be coined as "the Copperfield technique" ... you know, as we already have McGyver for other useful purposes.

quote:

not all sort value breaks equally to two pages

In that case you'll need to revise the COMPUTEd value to signify when the header should be "shown".

PRINT MODEL
      COMPUTE OVERFLOW_PAGE/A1     = IF COUNTRY EQ LAST COUNTRY THEN 'Y' ELSE 'N'; NOPRINT
-*      COMPUTE OVERFLOW_PAGE/A1 = IF (TABPAGENO - (INT(TABPAGENO / 2) * 2)) EQ 1 THEN 'N' ELSE 'Y'; NOPRINT
   BY COUNTRY
   BY CAR PAGE-BREAK

T

Thanks Tony. This was what i needed. Did not think it to be so simple and easy.Thanks again.

I changed the font size to 1, its perfect now.
TYPE=HEADING, LINE=5, COLOR=WHITE, SIZE=1, WHEN=OVERFLOW_PAGE EQ 'Y', $

-Hari

quote:

Originally posted by njsden:
"the Copperfield technique"

where can i find those Copperfield techniques?