Click here to Skip to main content
Click here to Skip to main content
Go to top

Generating PDF reports programmatically using SQL Server Reporting Services 2005, in C#

, 12 Sep 2006
Rate this:
Please Sign up or sign in to vote.
An article on how to generate PDF reports programmatically using SQL Server Reporting Services 2005, in C#.

Introduction

SQL Server Reporting Services (SSRS) 2005 is the latest version of the reporting technology from Microsoft. This article explains a way to create PDF reports programmatically using web services exposed by SQL Server Reporting Services 2005 in C#.

Using the code

First create a report which accepts boolean as its input parameter, and deploy that to the reporting server. The code below explains how to render the report in PDF format programmatically, using C#.

  • Step 1: Create and deploy the report.
  • Step 2: Add a web reference to the web services exposed by Reporting Services 2005, i.e., ReportExecution2005 and ReportService2005.
  • Step 3: Declare the following variables:
    private rs2005.ReportingService2005 rs;
    private rsExecService.ReportExecutionService rsExec;
  • Step 4: Initialize the web services and set the authentication for the web services.
    // Create a new proxy to the web service
    rs = new rs2005.ReportingService2005();
    rsExec = new rsExecService.ReportExecutionService();
    
    // Authenticate to the Web service using Windows credentials
    rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
    rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;
    
    // Assign the URL of the Web service
    rs.Url = "http://ICCW1023/ReportServer" + 
             "$REPORTSERVER2005/ReportService2005.asmx";
    rsExec.Url = "http://ICCW1023/ReportServer" + 
                 "$REPORTSERVER2005/ReportExecution2005.asmx";
  • Step 5: Write code to render the report in PDF format.
    // Prepare Render arguments
    string historyID = null;
    string deviceInfo = null;
    string format = "PDF";
    Byte[] results;
    string encoding = String.Empty;
    string mimeType = String.Empty;
    string extension = String.Empty;
    rsExecService.Warning[] warnings = null;
    string[] streamIDs = null;
    
    // Default Path;
    string fileName = @"c:\samplereport.pdf";
    
    // Define variables needed for GetParameters() method
    // Get the report name
    string _reportName = @"/MyReports/Report";
    string _historyID = null;
    bool _forRendering = false;
    ParameterValue[] _values = null;
    DataSourceCredentials[] _credentials = null;
    ReportParameter[] _parameters = null;
    
    try
    {
      // Get if any parameters needed.
      _parameters = rs.GetReportParameters(_report, _historyID, 
                    _forRendering, _values, _credentials);
    
      // Load the selected report.
      rsExecService.ExecutionInfo ei = 
            rsExec.LoadReport(_reportName, historyID);
    
      // Prepare report parameter.
      // Set the parameters for the report needed.
      rsExecService.ParameterValue[] parameters = 
             new rsExecService.ParameterValue[1];
    
      // Place to include the parameter.
      if (_parameters.Length > 0 )
      {
        parameters[0] = new rsExecService.ParameterValue();
        parameters[0].Label = "verzamelgroepAP";
        parameters[0].Name = "verzamelgroepAP";
        parameters[0].Value = "true";
      }
      rsExec.SetExecutionParameters(parameters, "en-us");
      results = rsExec.Render(format, deviceInfo, 
                out extension, out encoding,
                out mimeType, out warnings, out streamIDs);
    
      // Create a file stream and write the report to it
      using (FileStream stream = File.OpenWrite(fileName))
      {
        stream.Write(results, 0, results.Length);
      }
    }
    catch (Exception ex)
    {
      MessageBox.Show( ex.Message);
    }

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Sivakumar Mahalingam
Web Developer
France France
No Biography provided

Comments and Discussions

 
QuestionGenerating PDF reports programmatically using SQL Server Reporting Services 2005, in C# PinmemberAniket Banerjee17-Dec-13 0:04 
Questioncreate file on local machine Pinmemberisthmuskn15-Dec-13 13:03 
Questionabout adding web reference PinmemberMember 98555548-Oct-13 23:11 
GeneralMy vote of 9/10 Pinmembereka80814-Feb-12 4:40 
GeneralMy vote of 5 PinmemberMember 800638416-Sep-11 8:31 
GeneralOne or more data source credentials required to run the report have not been specified. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more data source credentials required to run the report have not been speci PinmemberDhruval Shah30-Jan-10 3:01 
GeneralRe: One or more data source credentials required to run the report have not been specified. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more data source credentials required to run the report have not been spec PinmemberIsta13-Jun-11 2:48 
GeneralC# Implmentation PinmemberMissy Casner23-Sep-09 3:51 
GeneralSample of url to reporting service Pinmemberd00_ape25-Aug-09 3:35 
GeneralTry this it will work. PinmemberM Varghese27-Jan-09 9:36 
GeneralRe: Try this it will work. PinmemberIsta30-Mar-10 5:46 
QuestionHow to export to PDF with password ? Pinmemberrajspselvaraj20-Nov-08 23:31 
AnswerRe: How to export to PDF with password ? PinmemberGufran Sheikh21-Mar-10 22:39 
GeneralPDF Performance PinmemberLautmann13-Nov-08 1:55 
GeneralTry this instead PinmemberMember 55285544-Oct-08 6:09 
GeneralRe: Try this instead PinmemberMember 55285544-Oct-08 6:18 
Generalpdf blank pages problem PinmemberMember 221258121-Jul-08 9:58 
Questioni have also the problem when exporting to pdf PinmemberMember 221258121-Jul-08 4:52 
GeneralCannot Create new Subscription SSRS Report...... Pinmembersriramjava5-Jun-08 3:22 
Questionblank pages for when I exported to pdf format? Pinmemberkuncha4-Jun-08 17:54 
GeneralGetting a large blank spaces while exporting to PDF Pinmemberenihar15-Apr-08 4:34 
GeneralRe: Getting a large blank spaces while exporting to PDF Pinmembertobiasboehler9-Sep-08 2:39 
GeneralProblems with reports that take parameters Pinmembermtembene22-Aug-07 10:39 
GeneralRe: Problems with reports that take parameters Pinmembermtembene22-Aug-07 11:44 
QuestionRe: Problems with reports that take parameters Pinmembershayles30-Mar-08 19:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 12 Sep 2006
Article Copyright 2006 by Sivakumar Mahalingam
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid