I’ve got the following requirement and I’m not sure if/how this can be accomplished in Crystal.
I have 3 versions of one report – the same .rpt file is used and its parts are suppressed based on the value in one of the data fields (report_type field). So let’s say the report has three pages: 1st page shows customer’s address, letter body, etc., 2nd page shows a detailed purchase transactions and 3rd page shows some “additional” information. Report’s pages are numbered 1 through 3.
When a user select an option to print the 2nd page only (report_type field has value 2) – the 1st and 3rd pages get suppressed and only 2nd page gets printed. The user wants to see “Page 2 of 3” printed in the page footer, and not “Page 1 of 1” (the way it is right now). Similarity, when they want to print 3rd page only, they want to see “Page 3 of 3” printed in the page footer.
The PageNofM function is used to determine the page number as compared to the total number of pages, at print time. Because certain pages are suppressed at print time, the PageNofM function is not able to determine what would have been the total number of pages if the report hadn’t been suppressed.
Please note that users do not want to run the “complete” report, go to print options and select pages they need to print so that the pages are numbered the way described above.
Any help would be greatly appreciated.