I have multiple reports (not tabs in a single report)
Now i want to enter custom Page number,
Like
Report 1 has 4 pages and total pages in 10 reports is 55, now the first report page number should be 1/55, 2/55, 3/55, 4/55
almost all the reports are master detail reports,
If i add a cell in the footer the value is unique in all the report, how to over come this problem.
NEO
KhoushikTTT 
(BOB member since 2005-02-24)
Try this formula:
=FormatNumber (Page()+2 , “#”)
or
=“Page " & FormatNumber (Page()+2 , “#”) & " of 55”
I added 2 to each page number. Of course it won’t be dynamic, but for printing, it should get you what you need.
djenkins (BOB member since 2002-12-12)
thanks for the reply but there are 5 reports with 11 pages, so if i add a cell then it reflects in all the pages and if i punch in the formula it will reflect in all the reports.
for individual pages in a report with 10 pages how do i define
NEO
KhoushikTTT (BOB member since 2005-02-24)
I must not fully understand what you are trying to accomplish. This is what I thought:
You have 10 reports (10 .rep files), each with a different number of pages. You want to print the reports with the page numbers going from 1 to 55 (combining all of the reports). In other words, you want:
[list]Report 1 has 10 pages, so the formula for the page numbers would be: ="Page " & FormatNumber (Page() , “#”) & “/55”
Report 2 has 4 pages, so the formula for the page numbers for that report would be (the +10 would take care of report1): ="Page " & FormatNumber (Page()+10 , “#”) & “/55”
Report 3 has 11 pages, so the formula would be (the +14 would take care of reports 1 and 2): ="Page " & FormatNumber (Page()+14 , “#”) & “/55”
etc. [/list]
Is this not what you were hoping for?
djenkins (BOB member since 2002-12-12)
You want the page numbering across the entire report, correct? In the print dialog box, there is an option in the lower right to number across all pages. No need to mess with formulas.
Dwayne Hoffpauir (BOB member since 2002-09-19)
but he said they are all different REPORTS not tabs within the same report…
djenkins (BOB member since 2002-12-12)
Ahh … I missed that part.
Dwayne Hoffpauir (BOB member since 2002-09-19)
WORKED PERFECT
Thanks all for all suggestion.
Its a stress filled project, its like creating atleast 2-6 reports everyday, I was hired as a reporter and its been like 23 reports in 3 weeks.
NEO
KhoushikTTT (BOB member since 2005-02-24)
Hang in there! It can only get better, right? And just think how good that number of reports will look on your resume!
dj
djenkins (BOB member since 2002-12-12)
DJ
got to run, i dont belive myself i have been working cont. for 100 hours with less than 15 hrs break.
True, resume will be wonderful.
Thanks for the supprot friends.
NEO
KhoushikTTT (BOB member since 2005-02-24)
This works if I directly print a .rep file. What if I save the report as pdf and the end user when prints the pdf the page numbering is broken for each tab? Any workaround!!
TIA!
BOB_DW (BOB member since 2004-08-26)