Wednesday, March 21, 2012

DynamicValuesUnavailable state using wsRS.GetReportParameters

This is a repost of a message from sqlserver.server of 9/1/2004 which is MSDN
managed, but there is no answer yet. So here goes in "reportingsvcs"
I am using the webservice ReportingService from the Reporting Services Web
Service Library.
I'm having a problem when retrieving Parameters for a RS report, valid
values are not returned when they are QueryBased.
It works fine when accessing the report through the RSServerName/reports
virtual dir. Then a dropdown with valid values for the parameter is perfectly
populated. As far as I know the "Reports" website uses the ReportingServices
WebService methods?!
When parameters are return from the GetReportParameters method, the
ReportParameters array is correct populated at first glance. The parameters
prm.ValidValuesQueryBased is True, but further investigation reveals that the
prm.ValidValues is nothing (VB) and the prm.State of the parameter is
DynamicValuesUnavailable. The prm.ValidValues is supposed to be an array of
the ValidValue class.....
I cannot seem to find any documentation why the prm.State is
DynamicValuesUnavailable. Has anyone tried this, and does anyone know a
solution?
Thanks GlennThanks Glenn! I had the same problem, and your workaround worked for me.
Ron
"SoGMo" wrote:
> I have now found the answer to my question. So for your information if anyone
> should need it:
> When invoking the method GetReportParameters on the ReportingServices
> service be sure to pass True as value for the ForRendering parameter. When
> this is done ValidValues are returned!
> /Glenn
> "SoGMo" wrote:
> > This is a repost of a message from sqlserver.server of 9/1/2004 which is MSDN
> > managed, but there is no answer yet. So here goes in "reportingsvcs"
> >
> > I am using the webservice ReportingService from the Reporting Services Web
> > Service Library.
> > I'm having a problem when retrieving Parameters for a RS report, valid
> > values are not returned when they are QueryBased.
> > It works fine when accessing the report through the RSServerName/reports
> > virtual dir. Then a dropdown with valid values for the parameter is perfectly
> > populated. As far as I know the "Reports" website uses the ReportingServices
> > WebService methods?!
> >
> > When parameters are return from the GetReportParameters method, the
> > ReportParameters array is correct populated at first glance. The parameters
> > prm.ValidValuesQueryBased is True, but further investigation reveals that the
> > prm.ValidValues is nothing (VB) and the prm.State of the parameter is
> > DynamicValuesUnavailable. The prm.ValidValues is supposed to be an array of
> > the ValidValue class.....
> >
> > I cannot seem to find any documentation why the prm.State is
> > DynamicValuesUnavailable. Has anyone tried this, and does anyone know a
> > solution?
> >
> > Thanks Glenn

No comments:

Post a Comment