I am having a problem with page numbering in my report. The user selects if they would like to print the current page, a particular section or the entire document. I want the page numbers to be the same for a particular record regardless of whether they choose to print current, section or all pages. So for instance, if the current record they are viewing would be page 10 if they chose to print the entire document then I want page 10 to appear if they choose to print the current page however, it prints page 1.
I have tried to get around it by doing the following:
1) I print the entire document
2) I increment the pages in code on the section_format routine
3) I have an if statement to determine if they record is the one that should actually be printed
4) if yes, then report.suppress = false
5) then I print the footer with the page number I have counted.
This almost works. Here is the issue (finally). If there is a record that is too long for one page and actually would be two pages but I am suppressing this record because it is not the one to be printed then it only counts it as one page not two so all of the page numbers after are incorrect. Does anyone know any way around this problem or does anyone have another solution to this problem? Please help if you can, I am desperate.
Thanks very much in advance!!
I have tried to get around it by doing the following:
1) I print the entire document
2) I increment the pages in code on the section_format routine
3) I have an if statement to determine if they record is the one that should actually be printed
4) if yes, then report.suppress = false
5) then I print the footer with the page number I have counted.
This almost works. Here is the issue (finally). If there is a record that is too long for one page and actually would be two pages but I am suppressing this record because it is not the one to be printed then it only counts it as one page not two so all of the page numbers after are incorrect. Does anyone know any way around this problem or does anyone have another solution to this problem? Please help if you can, I am desperate.
Thanks very much in advance!!