/// <summary>TBD</summary> /// <param name="customerId">TBD</param> /// <param name="results">TBD</param> public void GetWebResponse(string companyId, string customerId, out byte[] results) { SSRS_Reporting.ReportingService2005 reportingService = new SSRS_Reporting.ReportingService2005(); SSRS_Reporting.ReportExecutionService reportExecService = new SSRS_Reporting.ReportExecutionService(); reportingService.Credentials = CredentialCache.DefaultCredentials; reportExecService.Credentials = CredentialCache.DefaultCredentials; results = null; string historyId = null; string _historyId = null; string deviceInfo = null; string format = "EXCEL"; string encoding = string.Empty; string mimeType = string.Empty; string extension = string.Empty; string[] streamIDs = null; string reportName = "/TOD - Custom Reports/Billing Credits and Payments by Account"; bool _forRendering = false; SSRS_Reporting.Warning[] warnings = null; SSRS_Reporting.ParameterValue[] _values = null; SSRS_Reporting.DataSourceCredentials[] _credentials = null; SSRS_Reporting.ReportParameter[] _parameters = null; try { _parameters = reportingService.GetReportParameters(reportName, _historyId, _forRendering, _values, _credentials); SSRS_Reporting.ExecutionInfo ei = reportExecService.LoadReport(reportName, historyId); SSRS_Reporting.ParameterValue[] parameters = new SSRS_Reporting.ParameterValue[_parameters.Length]; if (_parameters.Length > 0) { parameters[0] = new SSRS_Reporting.ParameterValue(); parameters[0].Label = "companyId"; parameters[0].Name = "companyId"; parameters[0].Value = companyId; parameters[1] = new SSRS_Reporting.ParameterValue(); parameters[1].Label = "lookupType"; parameters[1].Name = "lookupType"; parameters[1].Value = lookupType.Value; parameters[2] = new SSRS_Reporting.ParameterValue(); parameters[2].Label = "searchText"; parameters[2].Name = "searchText"; parameters[2].Value = searchText.Value; parameters[3] = new SSRS_Reporting.ParameterValue(); parameters[3].Label = "customerId"; parameters[3].Name = "customerId"; parameters[3].Value = customerId; } SSRS_Reporting.ExecutionInfo execInfo = reportExecService.SetExecutionParameters(parameters, "en-us"); results = reportExecService.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs); } catch (Exception ex) { WebCommon.LogExceptionInfo(ex); } }
/// <summary>TBD</summary> /// <param name="invoiceNumber">TBD</param> /// <param name="results">TBD</param> public void GetWebResponse(string invoiceNumber, int companyId, out byte[] results) { SSRS_Reporting.ReportingService2005 reportingService = new SSRS_Reporting.ReportingService2005(); SSRS_Reporting.ReportExecutionService reportExecService = new SSRS_Reporting.ReportExecutionService(); reportingService.Credentials = CredentialCache.DefaultCredentials; reportExecService.Credentials = CredentialCache.DefaultCredentials; results = null; string historyId = null; string _historyId = null; string deviceInfo = null; string format = "PDF"; string encoding = string.Empty; string mimeType = string.Empty; string extension = string.Empty; string[] streamIDs = null; string reportName = (companyId == 1 ? "/SDS_Test/_wip/InvoiceReprint_WIP" : "/SDS_Test/_wip/InvoiceReprintCanada_WIP"); bool _forRendering = false; SSRS_Reporting.Warning[] warnings = null; SSRS_Reporting.ParameterValue[] _values = null; SSRS_Reporting.DataSourceCredentials[] _credentials = null; SSRS_Reporting.ReportParameter[] _parameters = null; try { _parameters = reportingService.GetReportParameters(reportName, _historyId, _forRendering, _values, _credentials); SSRS_Reporting.ExecutionInfo ei = reportExecService.LoadReport(reportName, historyId); SSRS_Reporting.ParameterValue[] parameters = new SSRS_Reporting.ParameterValue[1]; if (_parameters.Length > 0) { parameters[0] = new SSRS_Reporting.ParameterValue(); parameters[0].Label = "invoiceNumber"; parameters[0].Name = "invoiceNumber"; parameters[0].Value = invoiceNumber; } reportExecService.SetExecutionParameters(parameters, "en-us"); results = reportExecService.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs); //Response.Clear(); //Response.ContentType = "application/octet-stream"; //Response.AddHeader("content-disposition", "attachment; filename=test.PDF"); //Response.Write(results); //Response.Flush(); } catch (Exception ex) { WebCommon.LogExceptionInfo(ex); } }
/// <summary>TBD</summary> /// <param name="customerId">TBD</param> /// <param name="results">TBD</param> public void GetWebResponse(string contractNumber, out byte[] results) { SSRS_Reporting.ReportingService2005 reportingService = new SSRS_Reporting.ReportingService2005(); SSRS_Reporting.ReportExecutionService reportExecService = new SSRS_Reporting.ReportExecutionService(); reportingService.Credentials = CredentialCache.DefaultCredentials; reportExecService.Credentials = CredentialCache.DefaultCredentials; results = null; string historyId = null; string _historyId = null; string deviceInfo = null; string format = "EXCEL"; string encoding = string.Empty; string mimeType = string.Empty; string extension = string.Empty; string[] streamIDs = null; string reportName = "/TOD - Custom Reports/ContractSummary_PostingSchedule"; bool _forRendering = false; SSRS_Reporting.Warning[] warnings = null; SSRS_Reporting.ParameterValue[] _values = null; SSRS_Reporting.DataSourceCredentials[] _credentials = null; SSRS_Reporting.ReportParameter[] _parameters = null; try { _parameters = reportingService.GetReportParameters(reportName, _historyId, _forRendering, _values, _credentials); SSRS_Reporting.ExecutionInfo ei = reportExecService.LoadReport(reportName, historyId); SSRS_Reporting.ParameterValue[] parameters = new SSRS_Reporting.ParameterValue[_parameters.Length]; if (_parameters.Length > 0) { parameters[0] = new SSRS_Reporting.ParameterValue(); parameters[0].Label = "contractNumber"; parameters[0].Name = "contractNumber"; parameters[0].Value = contractNumber; } SSRS_Reporting.ExecutionInfo execInfo = reportExecService.SetExecutionParameters(parameters, "en-us"); results = reportExecService.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs); } catch (Exception ex) { WebCommon.LogExceptionInfo(ex); } }