Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Ali Adravi — Thu, 05 Nov 2009 05:36:43 GMT

Is that possible to send the report in mail as an atachment from SQL?

I have a report I want to mail it through a cheduling by creating a Job and chedule the report, is this possible?

If yes, could please send me the code or link.

Ali Adravi

Fakhruddin.ali@metaoption.com

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Doug — Thu, 27 Aug 2009 19:48:39 GMT

Dim rview As New Microsoft.Reporting.WebForms.ReportViewer()

'Web Address of your report server (ex: http:'rserver/reportserver)

' I used AppSettingsReader instead of WebConfigurationManager class

Dim apr As New AppSettingsReader()

rview.ServerReport.ReportServerUrl = New Uri(apr.GetValue("ReportServer", GetType(String)))

Dim paramList As New System.Collections.Generic.List(Of Microsoft.Reporting.WebForms.ReportParameter)

' set your parameters

paramList.Add(New Microsoft.Reporting.WebForms.ReportParameter("Param1", "Value1"))

paramList.Add(New Microsoft.Reporting.WebForms.ReportParameter("Param2", "Value2"))

' set the name of the reportPath

rview.ServerReport.ReportPath = "/ReportFolder/ReportName"

rview.ServerReport.SetParameters(paramList)

Dim mimeType As String = Nothing

Dim encoding As String = Nothing

Dim extension As String = Nothing

Dim deviceInfo As String = Nothing

Dim streamids As String() = Nothing

Dim warnings As Microsoft.Reporting.WebForms.Warning() = Nothing

Dim format As String = "PDF" 'Desired format goes here (PDF, Excel, or Image)

deviceInfo = "<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>"

Dim bytes As Byte() = rview.ServerReport.Render(format, deviceInfo, mimeType, encoding, extension, streamids, warnings)

Response.Clear()

If format = "PDF" Then

Response.ContentType = "application/pdf"

Response.AddHeader("Content-disposition", "filename=output.pdf")

ElseIf format = "Excel" Then

Response.ContentType = "application/excel"

Response.AddHeader("Content-disposition", "filename=output.xls")

End If

Response.OutputStream.Write(bytes, 0, bytes.Length)

Response.OutputStream.Flush()

Response.OutputStream.Close()

Response.Flush()

Response.Close()

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Luis — Mon, 17 Aug 2009 18:39:31 GMT

Does anyone have this code on visual basic??

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Bill — Thu, 25 Jun 2009 12:41:54 GMT

Has anyone tested this code using SSRS 2000?

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

George — Wed, 17 Jun 2009 15:39:37 GMT

I want to export SRS 2005 reports exactly into Excel 2007. Because the report that I generate contains much more information than it is possible to fit in Excel 2003. can anyone help me?.. thanks

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Admir — Thu, 28 May 2009 07:34:27 GMT

Thanx a lot

Works like charm

Any Idea how to this exported report attach to e mail and send

to someone.

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Gris — Thu, 07 May 2009 17:23:03 GMT

Hola

para este mensaje

Hi,

I want to export to PDF an report with params, Do you have any idea?

sorry, but I tried it, and i can't

Thank.

----------------------------------

Ejemplo:

Donde WRCustomers es el nombre del webservice

Dim RSGuardar As New WRCustomers.ReportExecutionService

Dim WRParam(0) As WRCustomers.ParameterValue

WRParam(0) = New WRCustomers.ParameterValue()

WRParam(0).Name = "Estato"

WRParam(0).Value = "6578"

' Cargo el report.

RSGuardar.LoadReport(Me.ReportViewer1.ServerReport.ReportPath, historyID)

RSGuardar.SetExecutionParameters(WRParam, "es-mx")

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Gris — Thu, 07 May 2009 17:00:17 GMT

Hi,

I want to export to PDF an report with params, Do you have any idea?

sorry, but I tried it, and i can't

Thank.

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Gris — Thu, 07 May 2009 16:55:17 GMT

Hi,

I want to export to PDF an report with params, Do you have any idea?

sorry, but I tried it, and i can't

Thank.

re: Exporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel

Christopher Smith — Wed, 06 May 2009 13:47:31 GMT

The above code works great, however is there a way to export multiple reports to an Excel file, with each report having it's own tab?

I want the user to be able to select one or more reports, hit a button and the result is one Excel file containing all the reports run.