SSRS 2008 R2 rendering ISSUES

Question

Hi All

1)when i renedered the report into word format  and trying to print the document we are getting an warning "the margins of section 1 are set outside the printable area" but we are not facing this issue when we rendered into PDF . 

2)blank pages are coming on even pages when we render into PDF

How to resolve these 2 issues .

---

Surendra Thota

Answer 1

Hi Surendra,

please confirm: Page Width and Length >= Body Width and Length >= Report Width and Length and let me know.

Let me know in case if it helps you or not.

Thanks !!!

---

Sachin Vashishth MCTS

Answer 2

Hi Sachin

can you please be more specific where to change these values .

---

Surendra Thota

Answer 3

Surendra,

Below is a screenshot shows your page area and its layout details in dialogue box.

.

Your report dotted area where your table/matrix control have been placed is called Body Area.

and your table/matrix control is Report Control.

So based on my above equation : Page Width and Length >= Body Width and Length >= Report Control Width and Length.

Hope this will make some sense to you, but let me know in case still have any doubts.

Thanks !!!

---

Sachin Vashishth MCTS

Answer 4

Hi Sachin

i am using 2008 R2 version . and here are the details you said

Page size : Width 29,7 cm   Height 21cm

Body size : Width 27,54062cm   Height 9,76308 cm

Tablix size : width 27,000244   Height 1,56188 cm

but i am having that issue .

---

Surendra Thota

Answer 5

Hi Sachin

and that too the issue is coming in word format only , in PDF there are no issues .

---

Surendra Thota

Answer 6

Hi Surendra,

For the first issue, if you set your document or section margins closer to the edge of the paper than your printer is capable of printing, Microsoft Word returns an error message when you send your document to the printer. You can manually increase the Top, Bottom, Left, and Right margins to the minimum required.  For more information about this issue, please see:
http://support.microsoft.com/kb/224061

For the second issue, in Reporting Services, the width of the report body, including margins, is not larger than the physical page size width. To prevent empty pages from being added to your report, you can reduce the container size by dragging the container corner to the left. Besides, there are white spaces preserved in the report body by default. When the white space extends the body size beyond the width of the report, blank pages will be generated.Please refer to the following suggestions to avoid the extra blank page:

• In the Report “Properties” pane, set the “ConsumeContainerWhitespace” to “True”.
• Reduce the size of the “Report Body” from the “Properties” pane, or reduce the container size by dragging the container corner to the left.

Please feel free to ask if you have anything unclear.

Regards,
Charlie Liao

Answer 7

Hi,

Please try to reduce the left,right,top and bottom margins from the Page Layout under page propertiesy default it is set to 1in.

Then export to word and let me know it works or not.

Thanks !!!

---

Sachin Vashishth MCTS

Answer 8

Hi All

what i observed is report header and footer is making problem in word printing. even what ever size i reduced for header and footer still iam geting the issue . if i remove the header and footer then its printing without error

---

Surendra Thota

Answer 9

HI All

still the problem is not solved . when we click the print icon in reporting server it is working fine ; but we render to word doc and then giving print it is not working .how to resolve this issue .

---

Surendra Thota

Answer 10

Hi Surendra,

The easiest way to avoid this issue is set the margin of your report a little big. I have tested it on my test environment. If I set the margin to 0.1in, then the issue appears, when I set the margin to 1in, the issue disappeared. Select Report in the Properties window, and set the margin to 1in. Please try it.

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

Answer 11

Hi Charlie

Great , it worked . thanks for your quick response and good work around .

---

Surendra Thota

Answer 12

Hi Charlie

when we click on print icon in reporting server web . we are getting error " Unable to load client print control" . how to solve this issue .

the clients doent have admin rights on their system  to install activeX commands . how to resolve this issue ?

---

Surendra Thota

Answer 13

Hi Surendra,

I suggest you to open a new question, you'll have a higher chance of getting an answer that way. I will work with you.

Regards,
Charlie Liao