Monday, February 20, 2012

Report Renders w/out parameters being selected

I have a report with a parameter list. The parameter has no default value.
When I open the report it renders without waiting for the parameter to be
selected and the parameter list is empty.
I ran SQL Profiler and the sproc that is used to populate the parameter list
is being run and I verified in Query Analyzer that the sproc is returning 4
values.
This same report runs ok on other environments (I have double checked an
uploaded the same RDL to multiple servers).
Any ideas? Is there a server setting that would control this?Try to delete report from server and re-deploy from report designer.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <noemail@.noemail.com> wrote in message
news:esAZuAcnFHA.1996@.TK2MSFTNGP10.phx.gbl...
>I have a report with a parameter list. The parameter has no default value.
> When I open the report it renders without waiting for the parameter to be
> selected and the parameter list is empty.
> I ran SQL Profiler and the sproc that is used to populate the parameter
> list is being run and I verified in Query Analyzer that the sproc is
> returning 4 values.
> This same report runs ok on other environments (I have double checked an
> uploaded the same RDL to multiple servers).
> Any ideas? Is there a server setting that would control this?
>

No comments:

Post a Comment