日期:2014-05-17 浏览次数:20674 次
SELECT TOP 1000 [ItemID] ,[Path] ,[Name] ,[ParentID] ,[Type] ,[Content] ,[Intermediate] ,[SnapshotDataID] ,[LinkSourceID] ,[Property] ,[Description] ,[Hidden] ,[CreatedByID] ,[CreationDate] ,[ModifiedByID] ,[ModifiedDate] ,[MimeType] ,[SnapshotLimit] ,[Parameter] ,[PolicyID] ,[PolicyRoot] ,[ExecutionFlag] ,[ExecutionTime] ,[SubType] ,[ComponentID] FROM [ReportServer$DBINstanceName].[dbo].[Catalog]
------解决方案--------------------
////报表服务器webservice操作类
ReportingService2010 _rs = new ReportingService2010(); //负责管理服务器的接口
_rs.Credentials = new System.Net.NetworkCredential(reportViewerUserName, reportViewerPassword, reportViewerDomain);
_rs.Url = String.Format("{0}/{1}", Common.ReadConfig.ReportServerUrl(), Common.EnumClass.ReportService2010.ToString() + ".asmx");
CatalogItem[] items;
items = _rs.ListChildren(Common.CommonClass.GetReportFileFolderPath(Common.ReadConfig.ReportProjectName()), true);
foreach (var item in items)
{
if (item.TypeName == "Report")
{
sb.Append("<li>");
sb.Append("<a href='Report/" + item.Name + "/" + "001' target='_blank'>" + item.Name + "</a>");
sb.Append("</li>");
}
}
this.myReportList.Text = sb.ToString();
自己参考吧,调用的webservice