Ssrs footer problems with multiple page batch reporting
Posted on 2014-04-11
I have a report with a header a footer and a sub report in the body. The sub report has keeptogether false because it can span more than one page. In print preview I will see the header and footer are missing most of the information (usually obtained from reportitems.)
The reportitems points at a table in the body of the report that gets data from the dataset. The problem appears to be that the row which has the subreport and spans two pages only seems to bring the reportitems with it that are part of the same row, that means rows above (and frankly below) which can fit on one page are written on the first page and the second page is unable to access those report items which are now considered blank by the report. How can I give the header and footer access to report items that may be on a different page from the one they are currently rendering?