.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

Traditional Chinese text flows into right Margin area when exporting to Word - SSRS 2008 R2

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


I've a Master Report which contains many sub reports. The page size is 11 X 8.5. I've set the .5 top & bottom margins for the Master page & set .5 left & right margins for all the sub reports.

The report renders fine when exporting to pdf. But while exporting to WORD it didn't show up any margins except left. So I copied just the Master page(for Word) and added an empty text box of size .5 on top & bottom. This work around works fine for English. But for Traditional chinese the text flows into right margin area. Left, Top & bottom margins are fine. And I really don't want to change the sub report settings since it works fine for pdf.

Any help would be appreciated!




View Complete Post

More Related Resource Links

SSRS 2008 Sum Calculation in text box

Hi,  Any one pls tell me how to calculate sum of text box values in SSRS 2008. (sum(Fields!Total_Days.Value, "DS_Monthday") - sum(Fields!Weekends.Value,  "DS_Weekends")) - (datediff("d",DATEADD("d",-(DAY(Today())-1),Today()),Today()))   * (Count(Fields!ClientID.Value, "DS_AVGRate")/Count(Fields!DimGPClientID.Value)) +  count(Fields!ClientID.Value, "DS_AVGRate"),Count(Fields!DimGPClientID.Value))   i want to calculate sum of the above expression in text box. I have tried it is showingerror  Aggregate function will not support in text box Pls help me to show the whole sum of above expression in text box only. Thanks in advance. Regards, Abdul2010

Is SSRS 2008 supports exporting to .xlsx format instead of .xls

I have MS Office 2007 installed in my machine. when i export SSRS 2008 report to Excel, i need to save in .xlsx format rather than .xls format. what settings we need to do. pls give me the solution for this. Thanks in advance.

Reporting Services 2008 - footer problem when exporting to Word


I have a footer that I want to show up on the last page only. 

I use the following expression for the text box under text box properties --> visability

=IIF(Globals!TotalPages = Globals!PageNumber,

False, True)

When I run the report in reporting services, it does only print the footer on the last page.  When exported to Word, footer prints on all pages.

My questions: 

1.  Is my expression ignored in Word for the footer, so I will not be able to do this in the footer?

2.  Is there another way to have something print at the bottom of the last page that will be recognized when exported to MS Word (report size will vary based on data returned)? 

Any help is appreciated.

Kind regards.

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.



SSRS 2005 to 2008 upgrade: exporting to .PDF does not produce the same result


We have recently converted .rdl SSRS 2005 files to SSRS 2008 .rdl files. We do not have SSRS 2008 R2, we are working with the  first release. We are seeing issues when exporing a report to .pdf format:

1) when rendered in HTML, the function that displays page numbers (ie:page 1 of 2) for the report are correct. The standard function "Globals!TotalPages" is used to get the count of pages. We previewed a report in html in reports manager that had 1777 pages. when the report is exported to .pdf the last page displays page 1777 of 1816, even though there is no more pages beyond 1777.

2)When rendering the report in html a value is shown as "Caretaker1" but when exporting to adobe .pdf version 9.3, the same value is shown as "Caretaker2".

3)   One of our issues is

SSRS 2008 export to Excel margin problem

When rendering report from SSRS 2008 with custom margins (let's say 0.5in) into Excel, margins do not export correctly, or do not export at all, thus Excel sets its default margins.

I heard in SSRS 2005 it was not a problem.

Any ideas?

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.


Blank Page at the end of Word Doument - SSRS 2008


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.






SSRS 2008 e-mail activity HTML - TEXT


Hi there

i've got description where i get from an email. Now i have HTML inside.

I created a placeholder but my problem is that I have images they aren't avaible now and i get an error.

is there a way to convert html to text without tags.


One who can read, have a clear advantage!

Does SSRS 2008 Support Rich Text Formatting?

Couldn't find any recent responses to this. Does anyone know if the 2008 version supports rich text formatting? Thanks

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!!!

How to rename excel worksheets after exporting report in SSRS 2008 R2



Is anyone aware of this new feature of 2008 R2. How to have the excel tabs renamed after the report will be exported to Excel. What properties I have to set to do the same.  ?


Word Automation Issue in Windows Server 2008 Hosting



The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.

With Regards,


How to change text in columns in SSRS?


I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.

Full text search in a Word document



  I´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:

1. Save a byte array from SQL server to word document as a temp file in a server side?

2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?

Thanks in advance,




Search does not find text in Word document stored in document library on a Report Center site within



We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?

Tamara Bredemus SharePoint Minion...working up to Maven
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