.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Blank Page at the end of Word Doument - SSRS 2008

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server

Hi there,

        I have 3 RDL files, 2 Sub Reports(RDLs) and 1 Main Report(RDL). Sub Reports are inside Rectangle Container.

ON Main Report: The body of this RDL has border set.

I have used two tables each with only 1 row and column to  put two sub Reports in those two Tables respectively. The first table have property set, Add A Page Break After = True

The second Table has , Add A Page Break After = False

This report shows 5 pages when i generate it with PDF and shows page border too.

but, when i generate it with Word, page border is not present and takes 1 extra blank page at the end of the report. i.e total 6 pages when export to Word.

Any 1 Any Idea how to supress that extra blank page from Word document.






View Complete Post

More Related Resource Links

Blank page while exporting to PDF formate from SSRS 2008


Hi there,

I am getting every other page blank while exporting to the PDF format in SSRS 2008. I have checked the page size, page margin or anything that is crossing my page size.  Everything looks fine, and still I am getting blank pages.  Your suggestions will be really helpful.  Thank you in advance.


SSRS 2008 - repeating a non column header column on every page

Hi - I am working on my first SSRS report and I have mostly all of it down except one issue. Per requirements, I need to display a column that is a non header column to repeat on every page while printing and or when I save the generated report in SSRS as a PDF file. I have seen some previous blog from 2007 where RepeatWith property is recommended to be set to the same name of the Tablix in which the column(s) are embeded, tried that but it is not working. Can any one help me on this or guide me how to resolve this? Thanks, Manny

SSRS 2008 group footer totals on a new page has a non-expected large cell height

SSRS 2008 group footer totals on a new page has a non-expected large cell height. When the group total is the first component on a new page, then this happens, but when it is part of the group on but not the first component, then it reverts to normal cell height. I have played with the advance settings now for hours, but cannot get this to work. Any ideas?  

SSRS Report issue blank page is coming

I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

Blank page while exporting the SSRS report to PDF format

While exporting SSRS report to PDF, I am getting blank page in between and at the end also. The report page size is set to 8.75in x 15.00in with 0.02in margin from left, right, bottom and top. I tried in changing the tablix and rectangle box "KeepTogether" property also. In both the case (true/false), I am getting blank pages. Can anyone help me out?

SSRS blank page iisue while export to pdf



I have added conditional page break in my ssrs report 2008 , because of blank page issue . After adding Conditional page break the blank page issue is fixed while i am preview the report. But if I export that to PDF alternate pages are coming as blank. I have checked the report width and body width and it is satisfying the condition, Please help to avoid this blank page issue while export to PDF

Jeeva Jacob

SSRS Report printing blank first page




I have a pretty basic SSRS report that has a table header, body (with a table), and table footer.  When I view the report in normal layout,all is well.  However, when I switch to print layout only the table header and table footer are displayed on the first page.  I don't see any of my table data until page two.  So, this is adding an additional page to the beginning of the report and it's make a 17 page report 18 pages.  And because I am including the page numbers on the report, this is noticeable to the users of the report obviously.  Any feedback on things I could do or check to remove this blank page would be greatly appreciated. 



How to Freeze page header SSRS 2008


Hi All,

Can someone tell me how to repeat page header on each page, i am using SSRS 2008.

Thanks in advance.

Font/letter spacing issue when printing from SSRS 2008 report page


We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

Page Breaks within tablix (SSRS 2008)



page breaks seem to be a real issue in SSRS, according to the number of posts, but I haven't found a solution for my problem yet.

My report contains a tablix which is used to group the data by keys. The tablix has one column and one row, and this cell contains several subreports which get their data from another table depending on the keys of the groups. This works quite well. However, I would like to insert a page break in between the subreports. I tried inserting a rectangle with the PageBreak property set to Start and/or End, but this is ignored. Page breaks in the subreports themselves are also ignored. Having the subreports in rectangles with PageBreak property set to Start or End is ignored as well.

The only way I have found to force page breaks is cross-joining my query of the main report with a table containing page numbers, add the page number field as the last grouping in SSRS and check the "Page breaks between each instance of the group", then showing or hiding the subreports conditionally depending on the page number retrieved from the database. However, this obviously multiplies the amount of retrieved data by the number of pages and is therefore a rather slow approach.

How can I insert a page break between rows of a tablix or even within one row?

We are using the Report Viewer control in local processing mode

ssrs 2008 export to word 2010



I am having an issue with the header on an rdl file (ssrs 2008) when I export to word 2010.  The header gets cut off at the top of the page (about .5 inch).  But when I export to a PDF file it is fine.  If all our users exported only to pdf this would not be an issue, but unfortunately our users use both word and pdf to print out the reports.



Table Header (Title) Row need to repeat on each page. How to do this in SSRS 2008 & above?



I have a requirement, where 1st row (Hearder) should repeat on each page.

For Example:



Experience in Years




So I want to repeat


SSRS 2005 Report Printing Additional Blank Page



New to SSRS 2005 and having some problems printing. I have a report that has only 7 columns and while in layout mode, the body of the report only has a width of not even 7 inches. I have made my left margin 0.2 in, RM at 0 in, TM at 0 in and BM at 0 in as well and yet when I print, I get an additional blank page. All my records print in the first page just fine but I get the additional blank page. This also happens to me on a different report when I change the settings for landscape printing. I am able to fit all the columns in one page using landscape but get an additional blank page for every page that is printed. So instead of printing just two pages of records, I get 2 additional blank pages.

Any help will be greatly appreciated.



Issue with Excel and Word Export - SSRS 2008


Hi there,

          I have created fairy simple report having a table in body section and Header, Footer. I have set the Report Properties

Orientation - Landscape

Paper Size - Custom

Width - 11in & Height - 8 in

Margins - Left 0.25 in , Right 0.25 in, Top 0.5 in, Botton 0.5 in

Issue NO 1: When i export the report to Excel, it takes margin as Left 0.75 in , Right 0.75 in, Top 1 in, Botton 1 in, because of this some part of my Report is cut. what should i do to keep margins of Excel as per margins set in RDL.

Issue No 2: In Footer excel shows Page 1 of 1 for all the pages

Expression used :



"Page" & Globals!PageNumber & " of " & Globals!TotalPages;

Issue No 3: when i export the Report to word, it does not consider landscape and show only middle part of report, cut rest of the report data.

Word Export error when orientation is Landscape in SSRS 2008


Hi there,

        I have created a report in SSRS 2008, In the report properties I have selected Orientation as Landscape but when i Export the report to Word it prints the report on middle of the page and cuts the rest of the report.

Urgent help is needed!!!

repeat row header on each page in ssrs 2008


Hi All,

 I am using Sql Server 2008 reporting services. I have a row on Group (tabular report), can anybody please tell me how to show report header while scrolling and on the each page.

Thanks in Advance.


Page numbering issue in SSRS 2008 R2 when converting to PDF

For rdl files created in SSRS 2008, the page numbering will render Page 1 of 0 but only for PDF.  Using OverallTotalPages instead of TotalPages only works on a 2008 R2 server.  On 2008, OverallTotalPages causes an error.

How do I get the page numbering to work on PDF without using OverallTotalPages?  I need to be able to change the files, do testing, then updgrade the SSRS instance.  I can't break existing SSRS 2008 reports.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend