Nesting Parameters

I'd like to have a chart with a category "group on" expression like this:

=Fields![Parameters!MyParameter.Value].Value

The above doesn't work. Is it because it can't be done, or because I don't have the right syntax?

Never mind. Found it:

=Fields.Item(Parameters!MyParameter.Value).Value

Nested iif using datepart

Could someone tell me if they see something off about this expression? I'm using it in an expression. It's giving me a syntax error.

=IIf(Fields!NTFrequency.Value = "Quarterly",IIf((DatePart("m", Now)=1), 9, month(now)-3, IIf((DatePart("m", Now)=1), 12,month(now)-1)))

Thanks, Iris

IIf((DatePart("m", Now)=1), 9, month(now)-3

Don't you need a closing parenthesis here?

|||

Yep, that worked!! Then I removed one at the end and no errors.

Thanks,

Iris

|||I get one right every now and again. Too much LISP experience, I guess.|||

LOL...I went cross-eyed looking at it. Needed a second set of eyes.

Iris

Nested IIF statement in jump to URL function

Afternoon
I am trying to do a "jump to URL" expression that works as follows:
=IIF(isnothing( A FIELD ) , iif crm url etc etc...... , iif crm url etc etc
........)
But as yet can not get it to work.
Has anyone tryed something simular?
Thanks
Steve DAnother option would be likely to use a computed column when extracitng the
data...
Else it's best to tell us anyway waht is the result you hvae. It should
work.
--
Patrice
"Steve Dearman" <steve.dearman@.grant.co.uk> a écrit dans le message de news:
uUvrLGQpGHA.4116@.TK2MSFTNGP03.phx.gbl...
> Afternoon
> I am trying to do a "jump to URL" expression that works as follows:
> =IIF(isnothing( A FIELD ) , iif crm url etc etc...... , iif crm url etc
> etc ........)
> But as yet can not get it to work.
> Has anyone tryed something simular?
> Thanks
> Steve D
>|||I'm using the jump to Url box in the properties of the cell im using, when i
run the report i get no errors but also the link doesn't show up at all
which would point to my multiple iif statement being invalid for this use.
Anyone else managed to do this some other way?
"Patrice" <scribe@.chez.com> wrote in message
news:%238EWsTRpGHA.3584@.TK2MSFTNGP05.phx.gbl...
> Another option would be likely to use a computed column when extracitng
> the data...
> Else it's best to tell us anyway waht is the result you hvae. It should
> work.
> --
> Patrice
> "Steve Dearman" <steve.dearman@.grant.co.uk> a écrit dans le message de
> news: uUvrLGQpGHA.4116@.TK2MSFTNGP03.phx.gbl...
>> Afternoon
>> I am trying to do a "jump to URL" expression that works as follows:
>> =IIF(isnothing( A FIELD ) , iif crm url etc etc...... , iif crm url etc
>> etc ........)
>> But as yet can not get it to work.
>> Has anyone tryed something simular?
>> Thanks
>> Steve D
>|||I sorted it out my self, thanks anyway.
When your using more than one IIF statement in the jump to url property you
need to use the full field name eg.
First(Fields!'field name'.Value , " ' dataset name' ") other wise it wont
work.
May work without first but i have not tryed it.
Steve D
"Steve Dearman" <steve.dearman@.grant.co.uk> wrote in message
news:eLDlQTYpGHA.2400@.TK2MSFTNGP03.phx.gbl...
> I'm using the jump to Url box in the properties of the cell im using, when
> i run the report i get no errors but also the link doesn't show up at all
> which would point to my multiple iif statement being invalid for this use.
> Anyone else managed to do this some other way?
>
> "Patrice" <scribe@.chez.com> wrote in message
> news:%238EWsTRpGHA.3584@.TK2MSFTNGP05.phx.gbl...
>> Another option would be likely to use a computed column when extracitng
>> the data...
>> Else it's best to tell us anyway waht is the result you hvae. It should
>> work.
>> --
>> Patrice
>> "Steve Dearman" <steve.dearman@.grant.co.uk> a écrit dans le message de
>> news: uUvrLGQpGHA.4116@.TK2MSFTNGP03.phx.gbl...
>> Afternoon
>> I am trying to do a "jump to URL" expression that works as follows:
>> =IIF(isnothing( A FIELD ) , iif crm url etc etc...... , iif crm url etc
>> etc ........)
>> But as yet can not get it to work.
>> Has anyone tryed something simular?
>> Thanks
>> Steve D
>>
>