Generating PDF or Excel or Image reports programmatically(C#, VB, .Net Same code can be Changed) using SQL Server Reporting Services 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://yourSSRSserver/ReportServer + 
           "$REPORTSERVER2005/ReportService2005.asmx";
  rsExec.Url = http://yourSSRSserver/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);
  }

For generating Other Report Formats(Eg: Excel, Images etc) one can simply change the beow code

string format = "PDF";

string fileName = @"c:\samplereport.pdf";

How to convert Chm files to Pdf ?

How to convert chm files to pdf? So why do we need to convert chm file to pdf? The reason is that chm file actually takes long time to load. For example, if you have a text book in chm file format. It’s around 100MB in size then switching between pages takes a long time and sometimes there might be chance of locking up your system. So how to tackle this problem?


So here comes pdf file. Although there will be reduction in large pdf file and it will be definetly faster then chm file. If we convert chm file to pdf then it might work out and solve our problem. So how to go for it. Well you can visit this website called convert chm to pdf and read the tutorials. It’s very easy. So just convert your chm file into pdf and start reading and what ever you want to do.

Note: - For Linux user, there is a very simple tool called chm2pdf. You give it the file name and it spews out a close to perfect PDF.

If you come across better then the site I referred you then please share with us here. I will update it for my readers. It will be beneficial for all of us.