I have a report with a Group header (NOT report / page header), a detail part (a continuous list of records), and a Group footer. Nothing else is in the report.
When there are not many records in the detail part, the header, detail and footer can fit in 1 page. But when there are more records, the footer is “pushed” to page 2. Sometimes it comes into a situation that all the records are able to fit in the first page and the footer goes to the second page alone. How can I make it like: if footer has to go to page 2 -> then at least 1 record is forced to go with it to page 2, even when there is enough space in page 1 to contain that record? I know this can be done in the settings but I tried tons of setting combinations and still couldn't make it!
When there are not many records in the detail part, the header, detail and footer can fit in 1 page. But when there are more records, the footer is “pushed” to page 2. Sometimes it comes into a situation that all the records are able to fit in the first page and the footer goes to the second page alone. How can I make it like: if footer has to go to page 2 -> then at least 1 record is forced to go with it to page 2, even when there is enough space in page 1 to contain that record? I know this can be done in the settings but I tried tons of setting combinations and still couldn't make it!