Friday, March 30, 2012

parameter problem

hi all,
i have a parameter ParamA that refers to another parameter ParamB.
select ParamA from property where chain like (@.ParamB+'%')
i set ParamB to allow blank value.
how do i enable ParamA if ParamB is blank? cos currently, ParamA will
be disabled for selection if @.ParamB is not specified. please help.
thanks!There is an allow null and a allow blanks propertu for parameters in
reporting services.
"minority" wrote:
> hi all,
> i have a parameter ParamA that refers to another parameter ParamB.
> select ParamA from property where chain like (@.ParamB+'%')
> i set ParamB to allow blank value.
> how do i enable ParamA if ParamB is blank? cos currently, ParamA will
> be disabled for selection if @.ParamB is not specified. please help.
> thanks!
>|||hi Jim, thanks for your reply.
there'll be an error if i set the parameter to allow null because the
available values are selected to be 'From Query'.|||both parameters are also multi-valued

No comments:

Post a Comment