Showing posts with label load. Show all posts
Showing posts with label load. Show all posts

Friday, March 30, 2012

Report parameter read only

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.
>

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

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)
>