日期:2014-05-17 浏览次数:20799 次
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