SSRS - No of Rows per page
-
Hi, I've used the following expression, to define the number of rows per page. =Int((RowNumber(Nothing)-1)/50) However the last row is displaying on a new page although the previous page does not exceed 50 rows. How can I prevent the last row from displaying on a new page?
-
Hi, I've used the following expression, to define the number of rows per page. =Int((RowNumber(Nothing)-1)/50) However the last row is displaying on a new page although the previous page does not exceed 50 rows. How can I prevent the last row from displaying on a new page?
I suspect the whole concept of defining a page length based on the number of rows is wrong. What happens if you reduce the height of the rows slightly. Page size has a defined length and each element within the page has it's own dimensions (rows, header, footer and groups) all of which affect the placement of the data relative to the page length.
Never underestimate the power of human stupidity RAH