March 2, 2008 at 10:11 am
I have a report using several parameters but every so often the list of parameters just disappears from the dataset parameters list and the report won't run. Is this a bug or does anyone have an explanation.
The other problem I have is how do I get the report to bypass the date parameters in my report and report back on all dates if this is what the user chooses.
March 3, 2008 at 4:53 am
As per my understandaing from your saying. Due to the repeated change of the parameter name in the datset may cause the change paramater name but it wont disappear as long you remove it.
For the date set the dafault value in expression as "Now".
March 4, 2008 at 7:38 am
I believe we are experiencing the same problem. Not all users experience this, and doesn't happen all the time for the users who do see it. The steps are: the user clicks on the report link, enters parameter values, and clicks View. At this point, the parameter all go blank and the report does not run.
I looked at the reporting services log files and found the following in the ReportServerWebApp file:
w3wp!ui!1!3/4/2008-08:09:20:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution '4thrwdm1343odt45wx0mvoq1' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
I'm not yet sure if this is related to my problem. I'm wondering if you are getting a similar error.
June 20, 2008 at 2:40 pm
Making any change to the SQL will cause the parameters to disappear. The only work-around is to reenter them.
November 25, 2008 at 7:56 am
That's not such a good workaround if the parameters just keep disappearing, even when you just switch to another tab in BIDS :crazy:
Has anyone else had this issue, the query has been designed and tested in management studio, but when it is pasted into a RS dataset everything turns smelly!
any help would be appreciated!
~~ Update ~~
solved my issue...
needed to convert a parameter defined as an integer to type int
convert(int, @Integer_Parameter)
This was then accepted by the parser and it did not delete all the defined parameters for me.
how stupid of me not to realise! 🙂
Assumption is the mother of all F***ups
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply