Sunday, February 19, 2012

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 :)
>

No comments:

Post a Comment