I did a search on the forum and did not seem to find the answer to my question, so I had to create a new topic. Here is the question:
I currently run a report that displays information for our customers, some can be one page, others can be up to 20. When I run it for multiple customers at a time, we have the report set up to start all customers on a new page.
We print these reports to be filed, however we are printing double sided and have run into the issue that if a customer has an odd number of pages on their report, it starts a new customer on the back side of the last page of the previous one.
We have added a blank cell at the bottom of the report to push the customer to a new page every time, however I would like to hide this cell if the page number is ‘even’ since the next customer will be starting on a new page anyways.
is it possible to use the hide when formula to hide the cell when page numbers are even? or is there another solution that I am not aware of?
I have the same situation and have run up against the same roadblock.
I’ve tried adding a blank cell to push each section instance (each customer) to a new page and then conditionally hiding the cell, but no matter how I do it the hiding doesn’t work. Here’s what I think is happening.
The PageInSection() function is the only way I can think of to define whether I need the blank page to display. But the documentation for that function says:
“If you place the PageInSection function in a cell whose Autofit Height or Autofit Width properties are set, the cell returns #RECURSIVE because the placing of this formula in an Autofit cell creates a circular dependency. This function needs the exact size of the report to return a value, but the size of the cell, which affects the size of the report, is determined by the cell content.” loading... | SAP Help Portal
Even though the error doesn’t come up, it must be occurring, since whether each instance of the cell is hidden or not will affect the size of the report. It seems like there should be a way to do this, though, since we don’t actually care about the length of the report, merely the length of the section.
I’m trying to think of a way around this, to define the length of a section instance without a function becoming #RECURSIVE, but I’m drawing a blank. Anyone have any ideas?