Report Builder 6.0.8.25.0
We have one report that is designed in the layout editor to have more than one vertical panel per page. The amount of data returned by each record is variable so we set the vertical panels per page to be 8 and the runtime variable BLANKPAGES=NO. This all works fine.
HOWEVER
We would also like to put page numbers and other information into the footer of each panel/page. We would normally do this by inserting fields into the margin of each panel and populating these fields programmatically. However because the number of panels per page varies at runtime if we insert fields into the margin of all 8 panels, and the record only spans 3,4,5,6 or 7 panels all additional panels still print because the field in the margin means the page is no longer blank.
So is there anyway to populated the margin of a report that contains a varying number of panels per page, so that only those panels with data print?