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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

SSRS 08 SP2 - Export to Word places the Footer 0.5" from the bottom

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

I am using SSRS 08 SP2.  I have a report that has top and bottom margins of 0.25".  This report also has a page header and footer.  When I export the report to Word, the page margin settings from the report export correctly to Word, BUT the footer is displayed 0.5" from the bottom and the header is displayed 0.5" from the top, so the document appears to have a .75" margin.  This can be edited in the Word document by clicking "Edit Footer" and then going to the design tab and changing the "Header from Top" and "Footer from Bottom" settings manually.  However, is there any way to change the report so it exports to Word with the correct margins automatically?  My users don't want to edit the report manually each time it is generated.

Also, this is not an issue when exported to PDF.  The margins are also not an issue if the page footer and header are removed and the report is exported to Word.  It only occurs with a report with page headers/footers that is exported to Word.  However, in my current project, it is not an option to use PDF and I cannot remove the page header/footer.




View Complete Post


More Related Resource Links

ssrs 2008 export to word 2010

  

Hello,

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.

 

Thanks


SSRS Word Export Issue- Last Column Data getting Trim

  

We are exporting a SSRS report in Word. The last colum is getting displayed without its right side vertical bar. Data is also getting trim. Please let us know the solution on this.

 


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


Export to Word and include an image

  
Hi, I am able to export a gridview and other tables into Word, but i want to include an image in this.  How is this possible.  If i do as below the image is not displayed. Please see my code below:         Response.Buffer = True        Response.ContentType = "Application/vnd.ms-word"        Response.ContentEncoding = System.Text.Encoding.Default        Response.AddHeader("content-disposition", "attachment;filename=participant_attendance.doc")        EnableViewState = False        Dim oStringWriter As System.IO.StringWriter = New System.IO.StringWriter        Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)         Dim style As String = "<style> .textmode { mso-number-format:\@; } </style>"        Dim table_text As String = String.Empty        Dim contact_text As String = String.Empty         ' Top table which contains the course information.    &nb

Export Multiple Gridviews To Word

  
Hi, I am trying to export multiple gridviews to Word.  I am able to do this but what i want to do is add some headings and text in between each grivdiew.  Please see my code below i am using to export the gridviews.         Response.Buffer = True        Response.ContentType = "Application/vnd.ms-word"        Response.ContentEncoding = System.Text.Encoding.Default        Response.AddHeader("content-disposition", "attachment;filename=evaluation_report.doc")        EnableViewState = False        Dim oStringWriter As System.IO.StringWriter = New System.IO.StringWriter        Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)         dv_course_information.RenderControl(oHtmlTextWriter)        gv_gp_practices.RenderControl(oHtmlTextWriter)        gv_attendance_summary.RenderControl(oHtmlTextWriter)        gv_useful_activities.RenderControl(oHtmlTextWriter)         Response.Write(oSt

Key press in SSRS to Enable print/Email/Export

  
Hi All   How do we enable key press to the Print/ Export button in SSRS  Also how to enable Email in SSRS   Regards  Sooraj

How to export SSRS report to PDF from SSIS with parameters

  
Hello everyone.  I am trying to setup a process in which a user, who is using a vb.net 2008 application, will need to  trigger the creation of two items.  The first is  SSRS report which will need to be exported to PDF format to a shared folder on the network.  This report accepts one parameter.  The second thing that will need to be created at the same time is an excel file with data exported from SQL Server 2008 which is generated through an SSIS package.  A couple things to note.  The excel file and the pdf file need to have the same file name, other than the extension.  For example P00000001_20100831.pdf and P00000001_20100831.xlsx and will both be stored in the same network share.  The filenames need to be created dynamically at run time and will be based on a parameter being passed to the report. So far I have the portion that creates the excel file working fine.  The way I create that is as follows.  I have a stored procedure that creates a job which calls the SSIS package and passes the appropriate parameters to the SSIS package.  After the job is created I immediately run it and then delete the job.  Ok, everything works fine with that. Now I cant seem to figure out how to get the pdf created.  If possible I would like to keep this portion together with the already created job or package.&nb

SSRS 2008 Export to PDF fails for large data with System.Exception: Parameter is not valid

  
Hi, We are working on Range Bar Chart using SSRS 2008. The report has huge data. It is properly displaying the data, but when we tried to export to pdf it is failing with the following exception. Exporting to excel works fine. Also if the report has small/medium data it is property exporting to PDF. It is failing only in case of huge data (we have custom page size of 28" X 14"). Of course the report has lot of expressions we used to customize the colors/text as per our requirements.   Server Error in '/Reports_SQLDEV2008' Application. Parameter is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Parameter is not valid. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:   [Exception: Parameter is not valid.]   [Exception: An error occurred during rendering of the report.]   [Exception: An error occurred during rendering of the report.]    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream ou

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?  

How do you freeze the tablix header row in an Excel export file in SSRS 2008?

  
So this is totally killing me. I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 (which I won't even get started on because all I can say is that 2005 is way better), but I cannot figure out how to make a simple header row of a tablix freeze in an Excel export file.  The tablix is right at the top of the body and spans the entire width of the design area.  How in the world do you get it to freeze in the Excel export file?

SSRS page break when export to PDF

  
Hi, I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices. I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer. My issue is after the header is printed, an automatic page break happens after the header and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape. I wish any one can solve this issue and grateful if they can give the solution for my problem. Thanks, Mahalingam

SSRS page break when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

Thanks,

Mahalingam


SSRS Report - Page break after the Header when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

Thanks,

Mahalingam

 


SSRS blank page iisue while export to pdf

  

Hi,

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

Create dynamic dropdown list when we export data to excel using SSRS.

  

Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?

Thanks,

Karthik 


SSRS 2005: Export to Excel, Tiff, and web archive all fail

  

SSRS Export to Excel is popular in our office but has been failing a lot recently- at the beginning of the year there were a few occurances a month until June, then they steadily increased until now it is nearly every time (44% of the events happened this month.)  Few software changes (just MS and virus def updates) No configuration changes until troubleshooting this issue began.  Policy changes on both server and clients is possible as that is controled by contractors and we are not notified of changes.

Upon exploring I discovered export to tiff and web archive also fail, but csv, PDF, and xml seems to work most of the time.   Some of the reports failing have not had any design changes in months.  Reports are not particularly large- 2 to 4 tables with under 200 rows each.  No more than 6 pages and then mostly because of page breaks between tables.  no more than 5 levels of drill down- most have fewer than that.  The failure happens very fast- about 4 seconds.  If the data is filtered down to very small sets so that the export process can complete inside those 4 seconds then it succeeds.

I have seem many questions on lots of forums with similar issues with SSRS but no solutions that worked for me.  All the timeout values I know of (about 6?) are set to between 120 and 3600 seconds.  None of my reports sh

Categories: 
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