I have tried all the tricks I know and this tiny report keeps making an extra blank page. I looked at the advanced group settings to turn on KeepTogether for every field I can find. I have no margins, and plenty of room on my page. I remove all the whitespace at the bottom and left. I removed the footer. What else can I try? Do you see anything I missed?
EarnedHoursDash.rdl (53.4 KB)
EarnedHours5NoParameters.baq (59.2 KB)
check on your margins, if you are out the margin for .00001 of an inch that extra space will create a new page. Review page and report margins, that happened to me many times.
Like others, I’ll open the RDL in VS Code and search for Width and see if any are greater than 11. The next thing is to look at Left + Length to see if they are over 11.
From Notepad++ I see nothing over 11"
C:\Users\nates\Desktop\reports\CustomReports\EarnedHoursDash.rdl (34 hits)
Line 647: 1.54354in
Line 912: 2.07167in
Line 927: 9.94in
Line 955: 0.84in
Line 982: 0.66in
Line 1010: 0.66in
Line 1039: 0.84in
Line 1068: 0.84in
Line 1096: 0.68in
Line 1125: 3.10417in
Line 1158: 0.78in
Line 1169: 9.60056in
Line 1201: 3.10417in
Line 1235: 2.32167in
Line 1265: 2.32167in
Line 1297: 3.10417in
Line 1317: 11in
Now, look around line 1317. Does that object have a Left > 0? That would push it off the edge.
Also, how many columns in that tablix? Could that be growing larger than the page width?
That 11" object is the pagewidth:
< PageHeight>8.5in< /PageHeight>
< PageWidth>11in< /PageWidth>
Are you printing this to screen or on paper?
This is a bigger pain and I’ve always wanted to whip up a PowerShell script to do this…
One more thing, search for Break in the RDL to make sure you know if any are turned on for groups, etc.
Print preview first, then I print it if needed. Second blank page is generated as part of the preview. Yea, I can choose to only print one page, but this is one of those frustratingly difficult things that should be easy. Just trying to get to the bottom of it. I thought I knew how to get rid of blank pages all the time, and I can’t figure this one out!
SSRS makes everyone’s day better!
None of our printers have zero margin so I always make the width 10.5in if printing in landscape mode.
No breaks reported in there. Regarding the powershell script, can you write a prompt to get GPT to write it for me? I think it would be something like: “Look at the XML file, add up the ‘width’ and any child 'left’s. Report the location of any width + left that is greater than 11.”
Same here. I read that one way to get rid of the extra page is to set margins to 0. So, I am taking the brute force approach and trying every option I can find.
Since you mention you have space to spare try making the page 10.75in maybe?
Negative. same result. So strange!
Usually, most printers cannot print completely to edge and most have a maximum nonprinting area around each edge of about .17 or .18 so I usually use .2 for margins and 8x10.5 for max page CONTENT size just to be safe.
I rebuilt it all from a new BAQReport. Now that I know how I want it setup I didn’t faff around. I just set it up correctly the first time. However, still I am getting a blank second page. I can’t see any good reason for it. Heck, I can’t even see any bad reasons for it! 
For the laughs, I deleted my tablix. Now there is nothing in my report besides the header. Still getting 2 pages!
