CODEWITHSUNDEEP
reporting-servicesssrs-tablix
Eric J
Eric J

Reputation: 222

Increasing Rows per Page in SSRS

I'm looking for a way to increase the number of rows per page in an SSRS report beyond 50. There are dozens upon dozens of guides on changing the rows per page via a parent group that breaks based on a CEILING(RowNumber(Nothing)/X) calculation, but every guide I've come across seems to be focused on decreasing the rows per page, and I want to increase the rows per page.

If I try a number higher than 50 for my breaks--CEILING(RowNumber(Nothing)/100), for example--it still caps the rows per page at 50. Using a number below 50 does work. Is there a report setting I've missed somewhere?

Upvotes: 3

Views: 3856

Answers (2)

iceblade
iceblade

Reputation: 641

A bit late, but today I was trying to do this same thing.

I managed to do it by going to Report Properties -> Page Setup and increase the Height property.

Report Properties can be opened by right clicking in the blank space outside the report working area.

Depending on the Height will be the number of elements in the page, in my case I was able to show 100 rows per page with a Height of 21.5in

Upvotes: 3

Alan Schofield
Alan Schofield

Reputation: 21683

No matter where you set pages breaks, if the content exceeds the page size then the page will break. I'm assuming that you are viewing on screen only in which case you need to increase the height of the report's interactive size property.

Upvotes: 0

Related Questions