Is there a way to auto fit a report page by height?

[Mark_vB]

Hi all,

We have dynamic number of columns in our cube views/reports and it changes the number of pages that the rows go over based on the number of columns and fitting the the width of the pages. 

Is there a way to make sure that the rows are set to a set number of pages high?

Thanks

[TheJonG · Accepted solution]

Unfortunately, there is not a "Fit to Height" property in the Cube View settings. You will have to adjust the row height settings until the report height fits the desired number of pages.

[Mark_vB]

Thanks for the reply. We have managed to "fit by height" by setting the Auto Fit to Page Width to False and then setting the font and margin sizes to fit the rows to the height of the page. This then keeps the text size the same and allows the columns to go over multiple pages as needed.