cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alienvolm
Helper IV
Helper IV

Border with extra space for one page only

Hi, 

 

I'm working on a paginated report and I cannot figure out why only one of the pages of my report is showing a page border larger than the other pages. 

 

This is the table in my Design space: 

 

Screen Shot 2021-04-27 at 12.46.30 PM.png

 

It expands dynamically, but I have a fixed number of values for [CurrentSpace] and it shouldn't go beyond the report margins. It doesn't even generate the extra white page. 

 

This is how I see the same table when I run the report:

Screen Shot 2021-04-27 at 12.49.20 PM.png

 

It looks like the columns do not maintain the width as I see it in the design, and then the border of the page goes into Landscape rather than Portrait. 

 

Any suggestions? 

 

Thanks in advance! 

 

~AlienVolm

1 ACCEPTED SOLUTION
AbhiSSRS
Solution Sage
Solution Sage

You need to remove the extra white space after the tablix on page. The way it renders is it will always add the space you left in design to the right of table after rendering the table fully , so you will see extra space and that may also cause a page break. So never leave extra space after your tablix in page specially if it has a grouped column. The width is maintained in exports unless we have "Keep Together", CanGrow etc set. also keep your column width in whole numbers eg 1in or upto 2 decimal places eg. 1.25in

View solution in original post

2 REPLIES 2
AbhiSSRS
Solution Sage
Solution Sage

You need to remove the extra white space after the tablix on page. The way it renders is it will always add the space you left in design to the right of table after rendering the table fully , so you will see extra space and that may also cause a page break. So never leave extra space after your tablix in page specially if it has a grouped column. The width is maintained in exports unless we have "Keep Together", CanGrow etc set. also keep your column width in whole numbers eg 1in or upto 2 decimal places eg. 1.25in

Thank you, I had to play a bit with it to understand what it does, but we are at an acceptable format now. 🙂

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.