Default Value in Report Parameter

I have put a Non-Queried Default Value parameter in a report and got an
error, 'Fields cannot be used in report parameter expressions.'
The expression I'm using:
=IIf(Fields!NTFrequency.Value = "Quarterly",IIf((DatePart("m", Now)=1), 9,
month(now)-3, IIf((DatePart("m", Now)=1), 12,month(now)-1)))
I don't understand what's wrong'
Thanks,
Iris> ... 'Fields cannot be used in report parameter expressions.'
> =IIf(Fields!NTFrequency.Value ...
you are basing your parameter off one of the fields, which doesn't
work. Fields generally depend on parameters, so they disallow
parameters depending on fields :)|||Thanks, changed it to 'Parameters' and it worked.
Iris
"tomisarobot@.gmail.com" wrote:
> > ... 'Fields cannot be used in report parameter expressions.'
> > =IIf(Fields!NTFrequency.Value ...
> you are basing your parameter off one of the fields, which doesn't
> work. Fields generally depend on parameters, so they disallow
> parameters depending on fields :)
>

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