Sunday, February 19, 2012

Default Value for Non-Queried Drop Down Parameter

I'm new to reporting services. Please forgive me if this is a stupid
question.
I have several different parameters in my report. Some are from
queries. I set my default value as Non-Queried with a valid value
from my query, and it works fine. Some of my other parameters are Non-
Queried where I have keyed in the appropriate labels and values. When
I run my report, I can see and select all of the values that I keyed.
I tried to set the default value as Non-Queried with a valid value
from the values that I keyed, and when I run my report, it still comes
up with Select a Value. Can you set defaults for Non-Queried
parameters? Why isn't this working?On Jul 11, 6:22 pm, kkrizl <kkr...@.co.el-dorado.ca.us> wrote:
> I'm new to reporting services. Please forgive me if this is a stupid
> question.
> I have several different parameters in my report. Some are from
> queries. I set my default value as Non-Queried with a valid value
> from my query, and it works fine. Some of my other parameters are Non-
> Queried where I have keyed in the appropriate labels and values. When
> I run my report, I can see and select all of the values that I keyed.
> I tried to set the default value as Non-Queried with a valid value
> from the values that I keyed, and when I run my report, it still comes
> up with Select a Value. Can you set defaults for Non-Queried
> parameters? Why isn't this working?
To use a default for a non-queried parameter, you need to set the
Default Value to one of the Values in the Available Values section. It
seems like you are setting it to a Label from the Available Values
section. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

No comments:

Post a Comment