How do I create a LINE NUMBER to number each of the 36 rows of (Detail Section) data that are displayed for each page of my report? (There's a total of 625 detail lines.)
The rows would be numbered 1 through 36 on Page 1, then begin at 1 again on Page 2 (for line #37), and so forth until the end of the report. The 625 lines, divided by the 36 lines per page, equals 17 full pages and a partial Page 18 which consists of the last 13 lines (which would be numbered 1 through 13)
I can create a text box that does the numbering, by selecting the Running Sum property, but I need the running sum to be for each page. The Running Sum property limits me to summing Over Group (which is my 625 lines) or Over All (which is also the 625 lines).