Greetings! I have a crosstab in the Report Footer of my Crystal Report in Crystal Reports 2013. The crosstab will often span multiple pages both horizontally and vertically. Right now, Crystal numbers the pages as follows (assume 3 horizontal pages and 2 vertical pages for this example):
1 1 1
2 2 2
The client would like the numbering (and the printing, in a PDF for example) to be:
1 3 5
2 4 6
The formula I want to use for page number is:
((horizontal_page_number - 1) * TotalPageCount) + PageNumber
However, I cannot reliably get horizontal_page_number. There was another thread where a similar question was posted 5 years ago, but the solution there does not work. It involved putting a formula into the HorizontalPageNumber field (in the Suppress or Display String formulas) to set a global variable to the value of the Horizontal Page Number field itself, and then using the global variable in another formula. Seems like it should work, but it does not. The global variable is not picked up by the new formula.
Any help would be greatly appreciated.