Hi,

I have code something like below. On the pdf report, when report1 starts it shows page number and when report 2 starts it shows page number as 1 again on PDF first page itself as per the below logic.
But what I want is, I don't want to repeat it on the same page, I want to show page number only once on each page. Can anybody know the solution?

I have to use this command for requirement as well.
ON TABLE SET PAGE NOLEAD

----------code starts--------

SET PAGE = OFF
SET COMPOUND = OPEN NOBREAK
-RUN
TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY
HEADING
"REPORT 1 ... PAGEON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER',
LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$
ENDSTYLE
END
-RUN
TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY
HEADING
"REPORT 2 ... PAGEON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER',
LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$
ENDSTYLE
END
-RUN
SET COMPOUND = CLOSE
TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY
HEADING
"REPORT 3 ... PAGEON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER',
LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$
ENDSTYLE
END

Thanks
Sandhya

This message has been edited. Last edited by: <Kathryn Henning>,

Checkout the usage of / Search on TABLASTPAGE. There are many posts on the subject. Or narrow your search to compound tablastpage.

Firstly, when posting code, please make sure that you use the code insert tags . That way we can see your full code posting without having to jump through hoops to help you

For everyone, this is the code that you posted -

SET PAGE = OFF
SET COMPOUND = OPEN NOBREAK
-RUN
TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY 
HEADING
"REPORT 1 ... PAGE<TABPAGENO"
ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER', 
LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$
ENDSTYLE
END
-RUN
TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY 
HEADING
"REPORT 2 ... PAGE<TABPAGENO"
ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER', 
LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$
ENDSTYLE
END
-RUN
SET COMPOUND = CLOSE
TABLE FILE CAR BY CAR BY MODEL SKIP-LINE BY MPG BY DCOST BY RCOST BY RPM BY COUNTRY 
HEADING
"REPORT 3 ... PAGE<TABPAGENO"
ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE, UNITS=IN, PAGESIZE='LETTER', 
LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.1, BOTTOMMARGIN=0.1,$
ENDSTYLE
END

Because you have nobreak within each report and have also coded <TABPAGENO in each heading section you will receive three page numbers for each run of this report.

Now, what do you want to have? If I read your post "as is", my first thought is that you only require the last report to include <TABPAGENO in the heading. But, imho, that would then not look so good, so please elaborate for us so that we can see exactly what you want.

I would also ask why you're persisting with the older style compound syntax and not the latest available to you? Is it that you are into coding in that manner for quite a while? If so then please allow me to recommend learning the newer syntax, it gives you greater control over you output layout and can provide more presentable outputs.

T

Hi Tony,

Thank You for you reply.

In all 3 page numbers I want to show only first one, I don't want to show the others.

You are mentioning about newer type of coding, can you please give me sample on CAR, I like to know the doing it in different way.
I have to finish this thing in 2 more days.

Thank You
Sanhdya