I have a user who likes their reports to display in PDF format. They also like to have the page count displayed on the report (Page 1 of 9). In some cases the page numbering and the PDF numbering are different and we end of with page 10 of 9. I'm sure this has to do with formatting. Has anyone else experienced this problem....? Is there a solution to get both Focexec Report and PDF correct...?

Thanks

My guess is you're using
TABPAGENO and TABLASTPAGE

We can't get it to work properly with WebFOCUS and PDF format, I think this is a bug.

We're on release 5.2.4

I'm 5.2.5 ..... I'll agree with the bug theory...

Looking at the knowledge base, it appears there are certain combinations of things that will cause this to happen.
Using some totals, PRINTPLUS=ON, etc

I think it is fixed in R53, but there may be some things that you can change to make it work in your release.

Can you reproduce this with the car file and show us the types of things that you are doing with your report?

I had this problem and the cause of it was the report was larger then the page it was trying to display on.

If your report is really wide try change it to landscape or legal sized page.

This code may help:
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.000000,RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,BOTTOMMARGIN=0.000000,$
PAGESIZE='LEGAL',ORIENTATION=LANDSCAPE,$
TYPE=REPORT,GRID=OFF,SIZE=8,SQUEEZE=ON,
FONT='ARIAL',$
ENDSTYLE

For our PDF reports, we used:

SET FOCFIRSTPAGE=1 (or set it to whatever # you want)
-RUN

TABLE FILE …

ON TABLE PCHOLD FORMAT PDF .. OPEN
END
-RUN

> We have multiple PDF reports that are -INCLUDEd from one FEX, so this variable will always be reset to 1.

> In your case, with 1 of 10 etc., you can use this setting with:

SET FOCFIRSTPAGE = &FOCNEXTPAGE
TABLE FILE ..

ON TABLE ... FORMAT PDF .. OPEN (for first rpt)

END
-RUN

SET FOCFIRSTPAGE = &FOCNEXTPAGE
TABLE FILE ..
:
2nd report etc.

END

> As long as you have all the PDF reports in the same FEX, and you use -RUN between each, it will increment (I don't think -RUN controls this; long story. But, remember that if you put a TABLE command between any of the reports and it just HOLDs or SAVEs data, the &FOCNEXTPAGE gets reset to 1. So, keep it all the PDF output together in one FEX if you can, hard code the "of 10" (or whatever based on the last TABLE command you have, and if they all produce one page, this will work, if not, more programming needed).

I hope this helps and makes sense.