Monday, July 02, 2012 10:33 AM
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
Monday, July 02, 2012 10:59 AM
I see no screen attached. It is possible to make header and footer to show up on every page.
Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/
Monday, July 02, 2012 12:36 PM
Sorry here is the attachment of scenario:
If data is with the table size defined then it is coming up properlyIf 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?
- Edited by Eswararao C Monday, July 02, 2012 12:49 PM
Monday, July 02, 2012 6:10 PM
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.
- Marked As Answer by Eswararao C Tuesday, July 03, 2012 3:50 AM
Tuesday, July 03, 2012 12:07 AMModerator
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.
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Tuesday, July 03, 2012 4:01 AM
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..:(
- Edited by Eswararao C Tuesday, July 03, 2012 4:01 AM
Tuesday, July 03, 2012 4:11 AMModerator
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.
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful