[CLOSED] Page numbers on Compounding No Break pdf reports

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

Posts: 53 | Registered: December 06, 2011

Doug

Expert

posted

Hide Post

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

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

Tony A

Expert

posted

Hide Post

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

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Sandhya j

Gold member

posted

Hide Post

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

WEBFOCUS 8202/Windows
PDF/HTML/XML

Posts: 53 | Registered: December 06, 2011

Ignored post by Sandhya j posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[CLOSED] Page numbers on Compounding No Break pdf reports

Focal Point | Privacy Statement | Terms of Service