sql server reporting services: DynamicValuesUnavailable -- sql server reporting services

DynamicValuesUnavailable

jsl
8/4/2005 10:37:55 AM

sql server reporting services: I am using the WS interface and returning reports for rendering will our UI.
I am successfully getting back the parameters. I would like to create a
drop down list box where appropriate for the parameters. So i iterate
through the ValidValues[]. This works fine for the exception of when those
values are driven from a secondary dataset in the report. In this case i
get the DynamicValuesUnavailable enum for the State and the ValidValues[] is
undefined value. I believe I have ruled out security in that both the main
report and the drop down are driven from the same shared data source. Any
Ideas?

Re: DynamicValuesUnavailable

jsl
8/4/2005 11:24:20 AM

Never mind - need to set ForRendering to true, although the one liner on
msdn below is a little misleading.

ForRendering
A Boolean expression that indicates how the parameter values are to be used.
If set to a value of true, parameter properties that are returned are based
on the parameter data that was used during the execution of the report.

[quoted text, click to view]