Search code examples
reporting-services

SSRS Exact copy of a table does not stay within the page


I am trying to set up a 3 part check where the header of the report is the check itself, and the next 2 sections are each a table with the detail data. One copy stays here while the other goes with the check as a stub. I want the data to be exactly the same and print on the same page. The problem I am having is that if I print 2 checks the second table does not appear on the first page but shows up on the second page with the second check (2 tables in the bottom of the second page). How do I get the second table to print on the page with the proper check? I have put both into a rectangle in the body but that has not helped.

I also need the second table to be in a specific location on the page so it can't be put into the first table since the number of detail rows may vary.


Solution

  • I finally got it working! Here is what I did. 1 - Created a subreport that holds the copy of the first table 2 - Added 2 rows below the detail group and put it outside of the group 3 - Put the subreport on the second added row 4 - Made the first added row below the detail big enough to force the subreport to be on the page where I want it.

    Here is what the rdl looks like in report builder enter image description here