Hi, all. I've got a report that contains two subreports. Both subreports pull the same number of rows each time the report is run. If the report's query returns 5 or fewer rows, the report is perfect; however, if it returns more than 5 rows, only the first 5 get displayed in each of the subreports, regardless of how many more records there are.
I know that, if I were to do everything in the Details section of the main report, I could tell the report to do "New Page After" and use the formula "if recordnumber mod 5 = 0 then true". This behavior would work for the report, but the problem is, I need it to work for the subreports as well. Unfortunately for me, it doesn't.
Say I have 7 records. What I'd like to do is to have both subreports display the first 5 on the first page, then the last 2 on the second page. Is there any way to achieve this beharior?
I know that, if I were to do everything in the Details section of the main report, I could tell the report to do "New Page After" and use the formula "if recordnumber mod 5 = 0 then true". This behavior would work for the report, but the problem is, I need it to work for the subreports as well. Unfortunately for me, it doesn't.
Say I have 7 records. What I'd like to do is to have both subreports display the first 5 on the first page, then the last 2 on the second page. Is there any way to achieve this beharior?