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