Using two WebServices exposed by SSRS to create PDF report formats programmatically

I had a requirement to automate the generation of PDF files of SSRS reports.

Figured out a way to use 2 webservices exposed by SQL Server Reporting Services 2005:
a. ReportService2005
b. ReportExecution2005

Implementation:
a. Create SSRS reports and deploy it on the report server.
b. In the windows application add reference to the 2 SSRS webservices: ReportService2005, ReportExecution2005
c. Set default report credentials.
d. Set 2 webservies url
e. Load the SSRS report using ReportExecution2005
f. Get SSRS reportparameters using ReportService2005, to get the total parameters in the report and set the appropriate parameters value to render the report using ReportExecution2005. (confused !!!. Check the code below)
g. Set report parameters using SetExecutionParameters() method of ReportExecution2005.
h. Render the report to get the PDF in byteArray format.
i. Write the pdf byteArray[] to the given pdf file using FileStream Class.

 

1. static private void CreatePDFReports()
2. {
3. //create proxy to the webservice
4. ReportService2005.ReportingService2005 rs2005 = new ReportService2005.ReportingService2005();
5. ReportExecution2005.ReportExecutionService re2005 = new ReportExecution2005.ReportExecutionService();
7. try
8. {
9. //authenticate to the web service using windows credentials
10. rs2005.Credentials = System.Net.CredentialCache.DefaultCredentials;
11. re2005.Credentials = System.Net.CredentialCache.DefaultCredentials;
12. rs2005.Url = ConfigurationSettings.AppSettings["ReportService2005.ReportService2005"];
13. re2005.Url = ConfigurationSettings.AppSettings["ReportExecution2005.ReportExecution2005"];
15. //prepare render arguments
16. string historyID = null;
17. string deviceinfo = null;
18. string format = "PDF";
19. byte[] bytPDF;
20. string encoding = string.Empty;
21. string mimeType = string.Empty;
22. string extension = string.Empty;
23. ReportExecution2005.Warning[] warnings = null;
24. string[] streamIDs = null;
26. //define variables needed for GetParameters() method
27. //get the report name
28. string _reportname = ConfigurationSettings.AppSettings["reportName"];
29. string _historyID = null;
30. bool _forRendering = false;
31. ReportService2005.ParameterValue[] _values = null;
32. ReportService2005.DataSourceCredentials[] _credentials = null;
33. ReportService2005.ReportParameter[] _parameters = null;
35. //load the selected report.
36. ReportExecution2005.ExecutionInfo ei = re2005.LoadReport(_reportname, historyID);
38. //Get the no. of parameters in the report.
39. _parameters = rs2005.GetReportParameters(_reportname, _historyID, _forRendering, _values, _credentials);
40. int totalParams = _parameters.Length;
42. ReportExecution2005.ParameterValue[] parameters = null;
44. //prepare report parameters
45. parameters = new ReportExecution2005.ParameterValue[totalParams];
47. foreach (ReportService2005.ReportParameter rp in _parameters)
48. {
49. switch (rp.Name)
50. {
51. case "param1_name":
52. {
53. parameters[_parameters.Length - totalParams] = new scheduleReports.ReportExecution2005.ParameterValue();
54. parameters[_parameters.Length - totalParams].Name = rp.Name;
55. parameters[_parameters.Length - totalParams].Value = 1;
56. }
57. break;
59. case "param2_name":
60. {
61. parameters[_parameters.Length - totalParams] = new scheduleReports.ReportExecution2005.ParameterValue();
62. parameters[_parameters.Length - totalParams].Name = rp.Name;
63. parameters[_parameters.Length - totalParams].Value = 100;
64. }
65. break;
66. }
67. totalParams--;
68. }
70. re2005.SetExecutionParameters(parameters, "en-us");
71. bytPDF = re2005.Render(format, deviceinfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
73. FileStream fs = new FileStream("report.pdf", FileMode.OpenOrCreate, FileAccess.Write);
74. fs.Write(bytPDF, 0, bytPDF.Length);
76. fs.Close();
77. }
79. catch (Exception ex)
80. {
81. Console.WriteLine(ex.Message);
82. Console.Read();
83. }
84. }