Got this error message while trying to load a sub-report from an existing
report and passing a parameter into the sub-report. I created the report
parameter just like it did for the source report. Please help.That means you forgot to provide a Prompt for the parameter in the
subreport.
Omitting the Prompt indicates to the server that the user should not be
prompted for a value (hence: read-only).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"John Cosmas" <vabo214@.msn.com> wrote in message
news:OKnfI3WZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Got this error message while trying to load a sub-report from an existing
> report and passing a parameter into the sub-report. I created the report
> parameter just like it did for the source report. Please help.
>
Showing posts with label load. Show all posts
Showing posts with label load. Show all posts
Friday, March 30, 2012
Monday, March 12, 2012
Report Manager in SQL Exprtess
I cannot get report manager to load in IE 7 after installing on SQL Express,
advanced edition. The error message is "The ReportServerVirtualDirectory
element is missing". When I check the reporting services configuration file,
there is no XML tag for this (Should there be?). In the reporting services
configuration manager, it shows as not being installed, but when I try to
install, it says it is. It is a little confusing, but basically on the
right-hand side it display a red "X" by report manager, but a green checkmark
on the left-hand side. Note that the report server loads fine in IE 7.On Sep 4, 2:14 pm, Craig Plank, SBS
<CraigPlank...@.discussions.microsoft.com> wrote:
> I cannot get report manager to load in IE 7 after installing on SQL Express,
> advanced edition. The error message is "The ReportServerVirtualDirectory
> element is missing". When I check the reporting services configuration file,
> there is no XML tag for this (Should there be?). In the reporting services
> configuration manager, it shows as not being installed, but when I try to
> install, it says it is. It is a little confusing, but basically on the
> right-hand side it display a red "X" by report manager, but a green checkmark
> on the left-hand side. Note that the report server loads fine in IE 7.
This article might help.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1532003&SiteID=17
Regards,
Enrique Martinez
Sr. Software Consultant
advanced edition. The error message is "The ReportServerVirtualDirectory
element is missing". When I check the reporting services configuration file,
there is no XML tag for this (Should there be?). In the reporting services
configuration manager, it shows as not being installed, but when I try to
install, it says it is. It is a little confusing, but basically on the
right-hand side it display a red "X" by report manager, but a green checkmark
on the left-hand side. Note that the report server loads fine in IE 7.On Sep 4, 2:14 pm, Craig Plank, SBS
<CraigPlank...@.discussions.microsoft.com> wrote:
> I cannot get report manager to load in IE 7 after installing on SQL Express,
> advanced edition. The error message is "The ReportServerVirtualDirectory
> element is missing". When I check the reporting services configuration file,
> there is no XML tag for this (Should there be?). In the reporting services
> configuration manager, it shows as not being installed, but when I try to
> install, it says it is. It is a little confusing, but basically on the
> right-hand side it display a red "X" by report manager, but a green checkmark
> on the left-hand side. Note that the report server loads fine in IE 7.
This article might help.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1532003&SiteID=17
Regards,
Enrique Martinez
Sr. Software Consultant
Report Manager Error
I am getting following error when trying to load the Report Manager:
The underlying connection was closed: Unable to connect to the remote
server.
This appears to be related to using SSL. If I point the config files
(RSReportServer.config & RSWebApplication.config) to http instead https and
set the SecureConnectionLevel to 0 I don't get this error; however, I need
use SSL
Does anyone have any ideas on what the problem could be?
Here is the stack trace from the log file:
w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: The underlying connection was
closed: Unable to connect to the remote server.
w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The underlying connection was closed: Unable to
connect to the remote server.
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
asyncResult)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!b14!8/26/2004-06:57:19:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)You may need to put in the full domain name of the server in the url in
RSWebApplication.config.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:OUaZY02iEHA.556@.tk2msftngp13.phx.gbl...
> I am getting following error when trying to load the Report Manager:
> The underlying connection was closed: Unable to connect to the remote
> server.
> This appears to be related to using SSL. If I point the config files
> (RSReportServer.config & RSWebApplication.config) to http instead https
and
> set the SecureConnectionLevel to 0 I don't get this error; however, I need
> use SSL
> Does anyone have any ideas on what the problem could be?
> Here is the stack trace from the log file:
> w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: The underlying connection was
> closed: Unable to connect to the remote server.
> w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The underlying connection was closed: Unable to
> connect to the remote server.
> at System.Net.HttpWebRequest.CheckFinalStatus()
> at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
> asyncResult)
> at System.Net.HttpWebRequest.GetRequestStream()
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at
Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!b14!8/26/2004-06:57:19:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>
The underlying connection was closed: Unable to connect to the remote
server.
This appears to be related to using SSL. If I point the config files
(RSReportServer.config & RSWebApplication.config) to http instead https and
set the SecureConnectionLevel to 0 I don't get this error; however, I need
use SSL
Does anyone have any ideas on what the problem could be?
Here is the stack trace from the log file:
w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: The underlying connection was
closed: Unable to connect to the remote server.
w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The underlying connection was closed: Unable to
connect to the remote server.
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
asyncResult)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!b14!8/26/2004-06:57:19:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)You may need to put in the full domain name of the server in the url in
RSWebApplication.config.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:OUaZY02iEHA.556@.tk2msftngp13.phx.gbl...
> I am getting following error when trying to load the Report Manager:
> The underlying connection was closed: Unable to connect to the remote
> server.
> This appears to be related to using SSL. If I point the config files
> (RSReportServer.config & RSWebApplication.config) to http instead https
and
> set the SecureConnectionLevel to 0 I don't get this error; however, I need
> use SSL
> Does anyone have any ideas on what the problem could be?
> Here is the stack trace from the log file:
> w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: The underlying connection was
> closed: Unable to connect to the remote server.
> w3wp!ui!b14!8/26/2004-06:56:32:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The underlying connection was closed: Unable to
> connect to the remote server.
> at System.Net.HttpWebRequest.CheckFinalStatus()
> at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
> asyncResult)
> at System.Net.HttpWebRequest.GetRequestStream()
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at
Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!b14!8/26/2004-06:57:19:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>
Subscribe to:
Posts (Atom)