Wednesday, March 28, 2012

Proplem w/Default Value for Parameter

I have a Parameter with 2 non-queried choices, Yes and No. I set the default
to No. When the report displays, instead of the default value displaying in
the dropdown, the users are being forced to choose. any ideas what would
cause this or how to fix?
TIA
deanI have a yes and no parameter. The labels say Yes and No and the values are
Y and N. You can either put in Y or ="Y" (either syntax works).
Also, it is case sensitive. So be sure the default you put in matches the
value not the label AND you are matching the case.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:Os5F3I6$HHA.4200@.TK2MSFTNGP04.phx.gbl...
>I have a Parameter with 2 non-queried choices, Yes and No. I set the
>default to No. When the report displays, instead of the default value
>displaying in the dropdown, the users are being forced to choose. any ideas
>what would cause this or how to fix?
> TIA
> dean
>|||I fixed this myself by deleting my deployed report and redeploying.
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:Os5F3I6$HHA.4200@.TK2MSFTNGP04.phx.gbl...
>I have a Parameter with 2 non-queried choices, Yes and No. I set the
>default to No. When the report displays, instead of the default value
>displaying in the dropdown, the users are being forced to choose. any ideas
>what would cause this or how to fix?
> TIA
> dean
>sql

No comments:

Post a Comment