Report printing blank sheet every second page

All replies

• 

  

  0

  Sign in to vote

  This is more than likely caused by page sizing / margin issues. 

  This is a good explanation of how to fix( taken directly from Stack Overflow)

  In BIDS, do the following:

  1. Click on Report > Report Properties > Layout tab
  2. Make a note of the values for Page width, Left margin, Right margin
  3. Close and go back to the design surface
  4. In the Properties window, select Body
  5. Click the + symbol to expand the Size node
  6. Make a note of the value for Width

  (Body Width + Left margin + Right margin) <= (Page width)

  Another thing to try is adding background colors to different elements like tables - this might give an indication of which element is spilling over onto the next page. 

  ---

  Jason Lattimer

  Tuesday, July 17, 2012 3:35 PM

  Moderator
• 

  

  0

  Sign in to vote

  I've tried that and it doesn't seem to be the problem.

  It is happening when I add a table to the report. It doesn't happen any other time.

  Wednesday, July 18, 2012 10:27 AM
• 

  

  0

  Sign in to vote

  I have just found another report of mine and it looks fine when you run it. I have a text box after a table that I have in the report and it appears on the report as the Table first then the textbox after the table.

  But when I print it the table is printed after the textbox which is the wrong way round.

  It seems to eb an issue with the tables when printing on both these occassions.

  Anyone any ideas?

  Wednesday, July 18, 2012 10:47 AM
• 

  

  0

  Sign in to vote

  Got this sorted myself.

  The table was too far from the boundary of the report so this caused the blank page .... strange microsoft stuff.

  • Proposed as answer by JLattimerMVP, Moderator Thursday, July 19, 2012 1:51 AM
  • Marked as answer by JMcCon Thursday, July 19, 2012 1:53 PM

  Wednesday, July 18, 2012 6:45 PM