Fixing the width of the report

Question

Hi Team,

Is it possible to Fix the width of the report in SSRS? i have created a header, footer and a table if the data is less in the table the report is coming properly but if the data occupies the entire page then the header and footer are showing an empty space (viewing it in reportviewer)(both header and footer are images).

Attached screen of the error

Answer 1

I see no screen attached. It is possible to make header and footer to show up on every page.

http://msdn.microsoft.com/en-us/library/ms159677(v=sql.100).aspx

http://technet.microsoft.com/en-us/library/dd220512.aspx

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 2

Sorry here is the attachment of scenario:

If data is with the table size defined then it is coming up properly

If data increase then there will be empty space even the table is within the header size

So i want to know if i can fix the size of header so that if the data is more it should go to next page in report viewer? 

Regards,

Eshwar.

Answer 3

I'm not certain this will fix the issue you appear to be having, but there was a property I stumbled upon that helped with the extra blank space that can often end up creating blank pages.  If you look under the report properties, under the other category, you will see ConsumeContainerWhitespace, try setting that to true.  I'm using visual studio 2008.

Answer 4

Hi There

Please try to adjust your margins (top + side) and hopefully this problem will get resolved

Body Width <= Page Width - (Left Margin + Right Margin)

Horizontal usable area:

X = Page.Width - (Left Margin + Right Margin + Column Spacing)

Vertical usable area:

Y = Page.Height - (Top Margin + Bottom Margin + Header Height + Footer Height)

Body Width <= Page Width - (Left Margin + Right Margin)
Horizontal usable area: 
X = Page.Width - (Left Margin + Right Margin + Column Spacing)
Vertical usable area: 
Y = Page.Height - (Top Margin + Bottom Margin + Header Height + Footer Height)

and as Marcusfenix33 suggests that you can also try to set the ConsumeContainerWhiteSpace property to True from the report properties pane. This can helps us avoid preserved white space in the report body

If you have any questions please ask.

Many Thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 5

Thanks Marcusfenix33 and Syed

It is working but it is possible to fix this issue both in PDF and reportviewer at the same time.

PDF still shows an empty..:(

Regards,

Eshwar.

Answer 6

Hi There

Thanks for your posting. Can you please place a rectangle on your report and try to put your tablix inside the rectangle.Please make sure that you your tablix  placed properly inside the rectangle  what I mean by that please first place rectangle to the report and then try to put your tablix by cut and paste, when you move the rectangle it will also move the tablix and see if it fix the problem

Please let me know if you have any questions.

Many thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful