Click here to Skip to main content
12,448,219 members (52,631 online)
Click here to Skip to main content
Add your own
alternative version

Stats

362.4K views
65 bookmarked
Posted

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

You may also be interested in...

Pro
Pro

Comments and Discussions

 
QuestionThe vb.net Equivalent Version Pin
Alex Lush17-Dec-15 23:12
memberAlex Lush17-Dec-15 23:12 
QuestionWell done sir! Pin
Alex Lush17-Dec-15 7:12
memberAlex Lush17-Dec-15 7:12 
GeneralI solved big problem which i faced using this article. Pin
Member 34355528-Jan-15 1:39
memberMember 34355528-Jan-15 1:39 
QuestionGenerating PDF reports programmatically using SQL Server Reporting Services 2005, in C# Pin
Aniket Banerjee17-Dec-13 0:04
memberAniket Banerjee17-Dec-13 0:04 
Questioncreate file on local machine Pin
isthmuskn15-Dec-13 13:03
memberisthmuskn15-Dec-13 13:03 
Questionabout adding web reference Pin
Member 98555548-Oct-13 23:11
memberMember 98555548-Oct-13 23:11 
GeneralMy vote of 9/10 Pin
eka80814-Feb-12 4:40
membereka80814-Feb-12 4:40 
GeneralMy vote of 5 Pin
Member 800638416-Sep-11 8:31
memberMember 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 Pin
Dhruval Shah30-Jan-10 3:01
memberDhruval 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 Pin
Ista13-Jun-11 2:48
memberIsta13-Jun-11 2:48 
GeneralC# Implmentation Pin
Missy Casner23-Sep-09 3:51
memberMissy Casner23-Sep-09 3:51 
GeneralSample of url to reporting service Pin
d00_ape25-Aug-09 3:35
memberd00_ape25-Aug-09 3:35 
GeneralTry this it will work. Pin
M Varghese27-Jan-09 9:36
memberM Varghese27-Jan-09 9:36 
GeneralRe: Try this it will work. Pin
Ista30-Mar-10 5:46
memberIsta30-Mar-10 5:46 
QuestionHow to export to PDF with password ? Pin
rajspselvaraj20-Nov-08 23:31
memberrajspselvaraj20-Nov-08 23:31 
AnswerRe: How to export to PDF with password ? Pin
Gufran Sheikh21-Mar-10 22:39
memberGufran Sheikh21-Mar-10 22:39 
GeneralPDF Performance Pin
Lautmann13-Nov-08 1:55
memberLautmann13-Nov-08 1:55 
GeneralTry this instead Pin
Member 55285544-Oct-08 6:09
memberMember 55285544-Oct-08 6:09 
GeneralRe: Try this instead Pin
Member 55285544-Oct-08 6:18
memberMember 55285544-Oct-08 6:18 
Generalpdf blank pages problem Pin
Member 221258121-Jul-08 9:58
memberMember 221258121-Jul-08 9:58 
Questioni have also the problem when exporting to pdf Pin
Member 221258121-Jul-08 4:52
memberMember 221258121-Jul-08 4:52 
GeneralCannot Create new Subscription SSRS Report...... Pin
sriramjava5-Jun-08 3:22
membersriramjava5-Jun-08 3:22 
Questionblank pages for when I exported to pdf format? Pin
kuncha4-Jun-08 17:54
memberkuncha4-Jun-08 17:54 
GeneralGetting a large blank spaces while exporting to PDF Pin
enihar15-Apr-08 4:34
memberenihar15-Apr-08 4:34 
GeneralRe: Getting a large blank spaces while exporting to PDF Pin
tobiasboehler9-Sep-08 2:39
membertobiasboehler9-Sep-08 2:39 
GeneralProblems with reports that take parameters Pin
mtembene22-Aug-07 10:39
membermtembene22-Aug-07 10:39 
GeneralRe: Problems with reports that take parameters Pin
mtembene22-Aug-07 11:44
membermtembene22-Aug-07 11:44 
QuestionRe: Problems with reports that take parameters Pin
shayles30-Mar-08 19:08
membershayles30-Mar-08 19:08 
GeneralHelp Getting Running... Pin
corpr812-Jun-07 11:20
membercorpr812-Jun-07 11:20 
GeneralRe: Help Getting Running... Pin
corpr813-Jun-07 2:33
membercorpr813-Jun-07 2:33 
GeneralRe: Help Getting Running... Pin
vikas chaudhary13-Jun-07 3:37
membervikas chaudhary13-Jun-07 3:37 
GeneralRe: Help Getting Running... Pin
corpr813-Jun-07 4:35
membercorpr813-Jun-07 4:35 
GeneralRe: Help Getting Running... Pin
corpr813-Jun-07 13:53
membercorpr813-Jun-07 13:53 
GeneralRe: Help Getting Running... Pin
JaneMcAbbey21-Aug-08 10:37
memberJaneMcAbbey21-Aug-08 10:37 
GeneralRe: Help Getting Running... Pin
JaneMcAbbey21-Aug-08 10:49
memberJaneMcAbbey21-Aug-08 10:49 
GeneralREGARDING REPORTNAME Pin
mahi988514-May-07 4:33
membermahi988514-May-07 4:33 
GeneralRe: REGARDING REPORTNAME Pin
vikas chaudhary31-May-07 18:53
membervikas chaudhary31-May-07 18:53 
GeneralCompletely lost... Pin
jbzcooper19-Apr-07 13:33
memberjbzcooper19-Apr-07 13:33 
QuestionAnyone actually able to open the pdf? Pin
qtran020317-Apr-07 10:33
memberqtran020317-Apr-07 10:33 
AnswerRe: Anyone actually able to open the pdf? Pin
qtran020318-Apr-07 3:39
memberqtran020318-Apr-07 3:39 
QuestionExporting XLS Files Pin
maskeye14-Apr-07 4:29
membermaskeye14-Apr-07 4:29 
AnswerRe: Exporting XLS Files Pin
maskeye14-Apr-07 5:28
membermaskeye14-Apr-07 5:28 
GeneralBig Help! Pin
Joe Krueger11-Apr-07 18:37
memberJoe Krueger11-Apr-07 18:37 
GeneralDoes not seem to work always Pin
bbzz2420-Mar-07 9:23
memberbbzz2420-Mar-07 9:23 
GeneralProblem in execution Pin
Zain51-Dec-06 3:39
memberZain51-Dec-06 3:39 
GeneralRe: Execution fine,But..... Pin
ihtamog28-Dec-06 0:49
memberihtamog28-Dec-06 0:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 | Terms of Use | Mobile
Web02 | 2.8.160811.3 | Last Updated 12 Sep 2006
Article Copyright 2006 by Sivakumar Mahalingam
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid