CODEWITHSUNDEEP
sql-serverssrs-2008reportingssrs-tablix
Andy K
Andy K

Reputation: 5044

SSRS - How to fit the content of a table into a single page for each table and not have part of the table spread between 2 pages

I have the following table (see the table below). It is querying into a table in my database, which has around 10 000 lines.

enter image description here

It starts well as you can (also below)

enter image description here

Issue is when going to the second page and after, the table is spreading around.

updated version after my wrong description: What I want actually is to have several tables in one page , with the last table complete with the 8 rows at the end of the page and have the next table start on another page.

I tried to set the tablix and the rectangle ,with the following properties:

 General
     KeepTogether = True
 PageBreak
     BreakLocation = End
     Disabled = False
     ResetPageNumber = False

However, it is still not giving me the desired results.

Any tips are more than welcomed

Upvotes: 0

Views: 2372

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31785

Put your table inside a List Item, and deactivate the Add a page break after in the List.

Or if you want to fit as many tables as possible on a page, but keep the page break from splitting them, here is how I have done this in the past:

  1. Create a sub-report that contains a single tablix for a single data entry.
  2. Put a single-celled tablix on your main report that gets the list of data entries for the full report.
  3. Put a rectangle inside the single cell.
  4. Put the sub-report inside the rectangle, and pass it the ID of the data entry.

Upvotes: 2

Related Questions