Wednesday, March 7, 2012

Expression for Jump to Report

Hi Experts,
Can anyone tell me how to specify an expression to be mentioned in the "Jump
to Report" in the Navigation tab. I basically dont want the hyperlink for
some values.
= iif( Fields!ItemCount.Value = 0, "", "Detail")
this is the expression which I have currently given. I dont want the
hyperlink when the ItemCount = 0. But now it points to the same page since I
have given empty string. How can I handle this.
Thanks in Advance
GaneshHi,
Instead of empty string just put "Nothing" word. This will solve your problem.
Regards
Amarnath
"Ganesh Ramamurthy" wrote:
> Hi Experts,
> Can anyone tell me how to specify an expression to be mentioned in the "Jump
> to Report" in the Navigation tab. I basically dont want the hyperlink for
> some values.
> = iif( Fields!ItemCount.Value = 0, "", "Detail")
> this is the expression which I have currently given. I dont want the
> hyperlink when the ItemCount = 0. But now it points to the same page since I
> have given empty string. How can I handle this.
> Thanks in Advance
> Ganesh
>
>|||Thanx Amar for the reply,
i tried that = iif( Fields!ItemCount.Value = 0, "Nothing", "Detail")...
I get the following error
The item '/Reports/Nothing' cannot be found. (rsItemNotFound)
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:3FEC77CE-9386-48E4-87CB-171F9EBBC053@.microsoft.com...
> Hi,
> Instead of empty string just put "Nothing" word. This will solve your
> problem.
> Regards
> Amarnath
> "Ganesh Ramamurthy" wrote:
>> Hi Experts,
>> Can anyone tell me how to specify an expression to be mentioned in the
>> "Jump
>> to Report" in the Navigation tab. I basically dont want the hyperlink for
>> some values.
>> = iif( Fields!ItemCount.Value = 0, "", "Detail")
>> this is the expression which I have currently given. I dont want the
>> hyperlink when the ItemCount = 0. But now it points to the same page
>> since I
>> have given empty string. How can I handle this.
>> Thanks in Advance
>> Ganesh
>>|||Amar..
Sorry for the Previous reply...now it is working correct...I had put Nothing
in quotes...
now it is working fine...quite a long time since worked in VB...
Thanks again
Ganesh
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:3FEC77CE-9386-48E4-87CB-171F9EBBC053@.microsoft.com...
> Hi,
> Instead of empty string just put "Nothing" word. This will solve your
> problem.
> Regards
> Amarnath
> "Ganesh Ramamurthy" wrote:
>> Hi Experts,
>> Can anyone tell me how to specify an expression to be mentioned in the
>> "Jump
>> to Report" in the Navigation tab. I basically dont want the hyperlink for
>> some values.
>> = iif( Fields!ItemCount.Value = 0, "", "Detail")
>> this is the expression which I have currently given. I dont want the
>> hyperlink when the ItemCount = 0. But now it points to the same page
>> since I
>> have given empty string. How can I handle this.
>> Thanks in Advance
>> Ganesh
>>

No comments:

Post a Comment