If you want to use the same method you will need to add a reference to to your project. The last step is to attach the report to a new email and load it up for the user, I’m using the Outlook interoperability assemblies. Using (FileStream fs = new FileStream(filename, FileMode.Create)) String filename = Path.Combine(Path.GetTempPath(), 'ReportToAttach.pdf') Out encoding, out filenameExtension, out streamids, out warnings) īytes = ('PDF', null, out mimeType, If (reportViewer1.ProcessingMode = ProcessingMode.Local)īytes = ('PDF', null, out mimeType, / Exports the current report out to a pdf file You will need to import these namespaces

To attach our report to an email the first step is to get the pdf file out to disk, I’m going to write a utility type function to achieve this which will return a filepath to the saved PDF file

Now when we run the application we are able to interact with the report. I’m using the a report stored on an SSRS server in this demo but you can also include reports locally in your solution, whichever option you choose does not affect the following steps.Ĭonfigure the report viewer to point to your report, I’m using a server based report so I have expanded the “ServerReport” property and specified a report server and a report path, I have also changed the “ProcessingMode” property to “Remote” to specify that I am using a remote report. Adding a ReportViewerįor this demo I’m starting with a blank form, first we need to drag a ReportViewer control onto the design surface. I’m doing this demo using VS2008 but it will work in exactly the same manner in VS2005. I’m using the inbuilt Outlook interoperability to achieve this but you could just as easily apply the same principles to another method of email delivery. Through the ReportViewer component users can view, export and print reports in exactly the same manner as the web based version but we also get some nice hooks into the ReportViewer control, I’m going to demo how we can use these to extract the report to a pdf and attach it to a new outlook message ready for the user to view and send. But SSRS is not restricted to this online portal style access, reports can be embedded into you application using the ReportViewer component shipped with Visual Studio.

SQL Server Reporting Services (SSRS) is Microsoft’s offering in the reporting space, if you install SSRS as part of a SQL Server install you get a nice web front end through which users can navigate and view reports.

Ssrs reportviewer