ssrs body looks right , report doesnt seem able to resize

  • Hi, i have been looking on the web for an answer but am coming up short.   Im stumped

    Im using an image i broke out from a word doc after saving it as html.   Im using it as a background for my new report.  The report will actually be a letter to certain customers whose content is based on some sql query results.  Basically the image looks like a very light gray watermark of the globe with our slogan left of that.  i also have our logo inserted as an image upper left.

    my body measures are 8 width by 10.5 height.   same with my report's and interactive sizes.    all margins are .25.   both the body and report have a border of 1 pt.  the report "property page" shows portrait and the same measures i just mentioned.

    even before i run the report, i see what appears to be too much report.  Its as if my report dimensions are being ignored.  I dont see any handles on the report region that i can use to squeeze it down.  when i run, i see the same thing.   the report appears to be generating much wider than 8.5 inches.

    when i remove the background image, same thing.   I did save an existing very wide report to make this one before removing all the visuals.  also when i reduce the body to 7.9 x 10.4 i get the same undesirable effect.

    at rendering when i hit "print layout" it looks more reasonable.   when i save to word once again i see a too wide report.  without the watermark and slogan .   when i save to pdf, i see a reasonable portrait report with watermark and slogan.   but 3 extra pages.

     

     

     

    • This topic was modified 1 day, 9 hours ago by  stan.
    • This topic was modified 1 day, 9 hours ago by  stan.
    • This topic was modified 1 day, 9 hours ago by  stan.
  • Are you able to post images showing the Report Properties?


  • these are the report props, will show body props separately

    phil90

    phil91

  • red shows background image.   2nd image is other properties pane of report that you get by rt clicking the report region.

    phil92

     

    phil93

  • "my body measures are 8 width by 10.5 height."

    Your page size is also 8 width by 10.5 height. With .25 inch margins, that only leaves 7.5 by 10.0 for the body.

    • This reply was modified 14 hours, 34 minutes ago by  ratbak.
  • thx, i will try changing that.   and post back here.

  • rendering in ssrs still has that wide look with no border.   hitting print layout in ssrs looks right.   saving to pdf is much better now in that watermark is still there, and there are no additional pages.   saving to word looks ridiculous in that its as wide as possible (what word allows without a slider bar) , and there is no background image.  in word under layout if i click 8.5 x 11 im ignored i think.   same with hitting portrait.

    • This reply was modified 12 hours, 7 minutes ago by  stan.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply