Remote accessing of reportserver using SSRS 2005
-
I am using SSRS 2005. Trying to connect reportserver remotely. and trying to fetch reports and collect on a treeview. But getting following error. This works fine, when the web server & sql server are on the same system. I mean works fine locally. Please help me. Error:: System.Web.Services.Protocols.SoapException: The item '/Sajan Reports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Sajan Reports' cannot be found. at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) Source codes Global.asax.cs ************** using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Web.Services.Protocols; using Microsoft.ReportingServices.Library.Soap2005; /// /// Summary description for Global /// public class Global : System.Web.HttpApplication { public void Application_Start(object sender, EventArgs e) { // Code that runs on application startup } public void Application_End(object sender, EventArgs e) { // Code that runs on application startup } public void Session_Start(object sender, EventArgs e) { // Code that runs on application startup Session["Uid"] = ""; } public void Session_End(object sender, EventArgs e) { // Code that runs when a session ends. } // Report Server defines the URL to root of the // Reporting Services home page. public static string ReportServer { get { return "http://10.10.40.2/reportserver"; } } // ReportPath, when appended to the ReportServer property, // will define the root of the report search. // For example, to view all available reports on the report // server, use "/" as the ReportPath. Setting the value to // "/MyDemoReports", would only show reports and subdirectories // under http://ReportServer/MyDemoReports. public static string ReportPat
-
I am using SSRS 2005. Trying to connect reportserver remotely. and trying to fetch reports and collect on a treeview. But getting following error. This works fine, when the web server & sql server are on the same system. I mean works fine locally. Please help me. Error:: System.Web.Services.Protocols.SoapException: The item '/Sajan Reports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Sajan Reports' cannot be found. at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) Source codes Global.asax.cs ************** using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Web.Services.Protocols; using Microsoft.ReportingServices.Library.Soap2005; /// /// Summary description for Global /// public class Global : System.Web.HttpApplication { public void Application_Start(object sender, EventArgs e) { // Code that runs on application startup } public void Application_End(object sender, EventArgs e) { // Code that runs on application startup } public void Session_Start(object sender, EventArgs e) { // Code that runs on application startup Session["Uid"] = ""; } public void Session_End(object sender, EventArgs e) { // Code that runs when a session ends. } // Report Server defines the URL to root of the // Reporting Services home page. public static string ReportServer { get { return "http://10.10.40.2/reportserver"; } } // ReportPath, when appended to the ReportServer property, // will define the root of the report search. // For example, to view all available reports on the report // server, use "/" as the ReportPath. Setting the value to // "/MyDemoReports", would only show reports and subdirectories // under http://ReportServer/MyDemoReports. public static string ReportPat
-
From the error message, it looks like the ServerReport.ReportPath property has been set with the report name missing. Is the value of Request["Path"] correct?
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
ServerReport.ReportPath is given in RenderReport.aspx page. Error is comming with ReportPath in the second line of the following code which is the next step: Is there any settings with using namespaces, missing .dlls or missing web reference. Please help me. Fetching and collecting on treeview with the following code ***************************************************************** rService.Credentials = new NetworkCredential("administrator", "password@sajan"); catalogItems = rService.ListChildren(Global.ReportPath,true); TreeView_Reports.Nodes.Clear(); RadTreeNode node16 = new RadTreeNode(); node16.Text = "Report"; TreeView_Reports.Nodes.Add(node16); TreeView_Reports1(TreeView_Reports, node16, catalogItems); After changing report path in Global.asax from get { return "/Sajan Reports"; } to get { return "/"; } I am getting following error. Can you please help me.:~ Error: System.Web.Services.Protocols.SoapException: The permissions granted to user 'MANOJ-SAJAN\IUSR_MANOJ-SAJAN' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'MANOJ-SAJAN\IUSR_MANOJ-SAJAN' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) -- modified at 5:47 Friday 16th November, 2007
-
ServerReport.ReportPath is given in RenderReport.aspx page. Error is comming with ReportPath in the second line of the following code which is the next step: Is there any settings with using namespaces, missing .dlls or missing web reference. Please help me. Fetching and collecting on treeview with the following code ***************************************************************** rService.Credentials = new NetworkCredential("administrator", "password@sajan"); catalogItems = rService.ListChildren(Global.ReportPath,true); TreeView_Reports.Nodes.Clear(); RadTreeNode node16 = new RadTreeNode(); node16.Text = "Report"; TreeView_Reports.Nodes.Add(node16); TreeView_Reports1(TreeView_Reports, node16, catalogItems); After changing report path in Global.asax from get { return "/Sajan Reports"; } to get { return "/"; } I am getting following error. Can you please help me.:~ Error: System.Web.Services.Protocols.SoapException: The permissions granted to user 'MANOJ-SAJAN\IUSR_MANOJ-SAJAN' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'MANOJ-SAJAN\IUSR_MANOJ-SAJAN' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) -- modified at 5:47 Friday 16th November, 2007
The following code is not working. This will make the tree. The following code line is not working. This should retrieve no. of reports from report server and put in array, catalogItems. Based on the number of reports the another loop will retrieve names of the reports and will populate the tree view. catalogItems = rService.ListChildren(Global.ReportPath,true); Help me please. -- modified at 7:33 Monday 19th November, 2007