public static Byte[] GetReportR2(string _reportName, string reportFormat, List <ReportParameter> _reportParameter)
{
// Byte[] result;
try
{
ReportingWebService.ReportExecutionService RS = new ReportingWebService.ReportExecutionService();
// CredentialCache cache = new CredentialCache();
string accessUser = WebConfigurationManager.AppSettings["WebServiceUser"]; // WebConfig.ReportUser();
string accessRWSPW = WebConfigurationManager.AppSettings["WebServiceWP"]; // WebConfig.ReportPW();
string accessDomain = WebConfigurationManager.AppSettings["NetWorkDomain"]; // WebConfig.DomainName();
string reportingServices = WebConfigurationManager.AppSettings["ReportingService"]; // WebConfig.ReportServices();
// string currentDB = DBConnectionHelper.CurrentDB();
string report = WebConfigurationManager.AppSettings["ReportPathWS"] + _reportName; // WebConfig.ReportPathWS() + "/" + _reportName;
string format = reportFormat; // getReportContentType(reportFormat); //WebConfigValue.ReportFormat();
RS.Url = reportingServices;
RS.Credentials = new System.Net.NetworkCredential(accessUser, accessRWSPW, accessDomain);
string historyID = null;
string devInfo = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
string encoding = "";
string mimeType = "";
ReportingWebService.Warning[] warnings = new ReportingWebService.Warning[0];
string[] streamIDs = null;
ReportingWebService.ServerInfoHeader sh = new ReportingWebService.ServerInfoHeader(); //'ServerInfoHeader
RS.ServerInfoHeaderValue = sh; //'ServerInfoHeaderValue = sh
// ReportingWebService.Warning warning = new ReportingWebService.Warning();
// MyCommon.MyParameterRS[] _reportParameter = GetReportParameters(_reportName, parameters);
// List<NVListItem> _reportParameter = GetReportParameters(_reportName, parameters);
var rptParameters = GetReportingServiceParameters(_reportParameter);
ReportingWebService.ExecutionInfo execInfo = new ReportingWebService.ExecutionInfo();
ReportingWebService.ExecutionHeader execHeader = new ReportingWebService.ExecutionHeader();
execInfo = RS.LoadReport(report, historyID);
RS.SetExecutionParameters(rptParameters, "en-us");
string extension = "";
string SessionId = RS.ExecutionHeaderValue.ExecutionID;
// Console.WriteLine("SessionID: {0}", RS.ExecutionHeaderValue.ExecutionID);
return(RS.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs));
// return result;
}
catch (Exception ex)
{
string error = ex.Message;
return(new Byte[0]);
}
}
private static Byte[] getPDFReport(ReportBase reportPara, List <ReportParameter> _reportParameter)
{
// Byte[] result;
try
{
ReportingWebService.ReportExecutionService RS = new ReportingWebService.ReportExecutionService();
// CredentialCache cache = new CredentialCache();
string accessUser = WebConfigurationManager.AppSettings["WebServiceUser"]; // WebConfig.ReportUser();
string accessRWSPW = WebConfigurationManager.AppSettings["WebServiceWP"]; // WebConfig.ReportPW();
string accessDomain = WebConfigurationManager.AppSettings["NetWorkDomain"]; // WebConfig.DomainName();
// string reportingServices = WebConfigurationManager.AppSettings["ReportingService"];// WebConfig.ReportServices();
// string reportPath = WebConfigurationManager.AppSettings["ReportPathWS"];// WebConfig.ReportPathWS() + "/" + _reportName;
string format = reportPara.ReportFormat;
RS.Url = reportPara.ReportService;
RS.Credentials = new System.Net.NetworkCredential(accessUser, accessRWSPW, accessDomain);
string report = reportPara.ReportPath + reportPara.ReportName;
string historyID = null;
string devInfo = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
string encoding = "";
string mimeType = "";
ReportingWebService.Warning[] warnings = new ReportingWebService.Warning[0];
string[] streamIDs = null;
ReportingWebService.ServerInfoHeader sh = new ReportingWebService.ServerInfoHeader();
RS.ServerInfoHeaderValue = sh;
var rptParameters = GetReportingServiceParameters(_reportParameter);
ReportingWebService.ExecutionInfo execInfo = new ReportingWebService.ExecutionInfo();
ReportingWebService.ExecutionHeader execHeader = new ReportingWebService.ExecutionHeader();
execInfo = RS.LoadReport(report, historyID);
RS.SetExecutionParameters(rptParameters, "en-us");
string extension = "";
string SessionId = RS.ExecutionHeaderValue.ExecutionID;
return(RS.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs));
}
catch (Exception ex)
{
string error = ex.Message;
return(new Byte[0]);
}
}
public static Byte[] GetReportR2(string _reportName, MyADO.MyParameterRS[] _reportParameter)
{
Byte[] result;
try
{
ReportingWebService.ReportExecutionService RS = new ReportingWebService.ReportExecutionService();
// CredentialCache cache = new CredentialCache();
string accessUser = WebConfig.ReportUser();
string accessRWSPW = WebConfig.ReportPW();
string accessDomain = WebConfig.DomainName();
string reportingServices = WebConfig.ReportServices();
string currentDB = DBConnection.CurrentDB;
string report = WebConfig.ReportPathWS() + currentDB + "/" + _reportName;
string format = WebConfig.ReportFormat();
RS.Url = reportingServices;
RS.Credentials = new System.Net.NetworkCredential(accessUser, accessRWSPW, accessDomain);
string historyID = null;
string devInfo = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
string encoding = "";
string mimeType = "";
ReportingWebService.Warning[] warnings = new ReportingWebService.Warning[0];
string[] streamIDs = null;
ReportingWebService.ServerInfoHeader sh = new ReportingWebService.ServerInfoHeader(); //'ServerInfoHeader
RS.ServerInfoHeaderValue = sh; //'ServerInfoHeaderValue = sh
// ReportingWebService.Warning warning = new ReportingWebService.Warning();
int pLeng = _reportParameter.Length;
ReportingWebService.ParameterValue[] rptParameters = new ReportingWebService.ParameterValue[pLeng];
int i = 0;
foreach (MyADO.MyParameterRS para in _reportParameter)
{
rptParameters[i] = new ReportingWebService.ParameterValue();
rptParameters[i].Name = para.pName;
rptParameters[i].Value = para.pValue.ToString();
i += 1;
}
// ReDim rptParameters(cnt - 1)
ReportingWebService.ExecutionInfo execInfo = new ReportingWebService.ExecutionInfo();
ReportingWebService.ExecutionHeader execHeader = new ReportingWebService.ExecutionHeader();
execInfo = RS.LoadReport(report, historyID);
RS.SetExecutionParameters(rptParameters, "en-us");
string extension = "";
string SessionId = RS.ExecutionHeaderValue.ExecutionID;
// Console.WriteLine("SessionID: {0}", RS.ExecutionHeaderValue.ExecutionID);
result = RS.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
return(result);
}
catch (Exception ex)
{
string error = ex.Message;
return(new Byte[0]);
}
}
public static Byte[] GetReportR3(string reportingServices, string reportPath, string reportName, string reportFormat, List <ReportParameter> _reportParameter)
{
// Byte[] result;
try
{
ReportingWebService.ReportExecutionService RS = new ReportingWebService.ReportExecutionService();
// CredentialCache cache = new CredentialCache();
string accessUser = WebConfigurationManager.AppSettings["WebServiceUser"]; // WebConfig.ReportUser();
string accessRWSPW = WebConfigurationManager.AppSettings["WebServiceWP"]; // WebConfig.ReportPW();
string accessDomain = WebConfigurationManager.AppSettings["NetWorkDomain"]; // WebConfig.DomainName();
// string reportingServices = WebConfigurationManager.AppSettings["ReportingService"];// WebConfig.ReportServices();
// string reportPath = WebConfigurationManager.AppSettings["ReportPathWS"];// WebConfig.ReportPathWS() + "/" + _reportName;
string format = reportFormat; // getReportContentType(reportFormat); //WebConfigValue.ReportFormat();
RS.Url = reportingServices;
RS.Credentials = new System.Net.NetworkCredential(accessUser, accessRWSPW, accessDomain);
string report = reportPath + reportName;
string historyID = null;
string devInfo = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
string encoding = "";
string mimeType = "";
ReportingWebService.Warning[] warnings = new ReportingWebService.Warning[0];
string[] streamIDs = null;
ReportingWebService.ServerInfoHeader sh = new ReportingWebService.ServerInfoHeader();
RS.ServerInfoHeaderValue = sh;
var rptParameters = GetReportingServiceParameters(_reportParameter);
//int pLeng = _reportParameter.Count;
//ReportingWebService.ParameterValue[] rptParameters = new ReportingWebService.ParameterValue[pLeng];
//int i = 0;
//foreach (var item in _reportParameter)
//{
// rptParameters[i] = new ReportingWebService.ParameterValue()
// {
// Name = item.ParaName,
// Value = item.ParaValue.ToString()
// };
// i += 1;
//}
ReportingWebService.ExecutionInfo execInfo = new ReportingWebService.ExecutionInfo();
ReportingWebService.ExecutionHeader execHeader = new ReportingWebService.ExecutionHeader();
execInfo = RS.LoadReport(report, historyID);
RS.SetExecutionParameters(rptParameters, "en-us");
string extension = "";
string SessionId = RS.ExecutionHeaderValue.ExecutionID;
return(RS.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs));
}
catch (Exception ex)
{
string error = ex.Message;
return(new Byte[0]);
}
}