run report through call reporting services web service

最新推荐文章于 2024-08-04 09:50:56 发布

匆匆过客121

最新推荐文章于 2024-08-04 09:50:56 发布

阅读量452

点赞数

分类专栏： .Net Reporting Service 文章标签： report service web warnings string encoding

本文链接：https://blog.csdn.net/kuui_chiu/article/details/6947183

版权

.Net 同时被 2 个专栏收录

114 篇文章 0 订阅

订阅专栏

Reporting Service

10 篇文章 0 订阅

订阅专栏

SQLRS2005.ReportExecutionService rs = new SQLRS2005.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
rs.UseDefaultCredentials = true;
					
byte[] result = null;
// Path of the report in reporting services (like /OrgName_MSCRM/4.0/{ID_OF_The_Report}
string reportPath = System.Web.HttpUtility.UrlDecode(reportName);
string format = "PDF";
string historyID = null;
string devInfo = @"<DeviceInfo><Toolbar>False</Toolbar><StartPage>0</StartPage></DeviceInfo>";


SQLRS2005.ExecutionInfo info = rs.LoadReport(reportPath,historyID);

// Prepare report parameter.
SQLRS2005.ParameterValue parameter = new SQLRS2005.ParameterValue();
// filtered View is the name of the CRM filtered view
parameter.Name = filteredView;

// sqlFilter is the prefiltering SQL query
parameter.Value = sqlFilter;
				
rs.SetExecutionParameters(new SQLRS2005.ParameterValue[] { parameter } , null); 

string strExtensions; 
string encoding;
string mimeType;

SQLRS2005.Warning[] warnings = null;
string[] streamIDs = null;
					
result = rs.Render(exportType, devInfo, out strExtensions, out 
						mimeType, out encoding, out warnings, out streamIDs);

http://social.microsoft.com/Forums/zh-CN/crm/thread/c6d77fdd-4a9e-4a8c-8ec6-6ed0253693f6