How To Toggle Hyperlink depending on data value
Newbie in SSRS--I'm using SSRS 2008, and in TEXTBOX properties, how do I enable the hyperlink on a report item depnding on it's value (e.g. greater than 0, then enable hyperlink)? The ACTION menu item just enables the hyperlink but there is no expression
to toggle that property.
TIAJag Gutz
November 23rd, 2010 2:15pm
I think in current version this is not possible,
instead of you can use two text box,
One with hypelink other without.
and Show and hide one of them based on you condition.
this will work for you.
Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 2:47pm
Sounds like a great idea. I think that will work. Except I'm not too sure how to add another text box to row/column in tablix where it's been assigned already to a field in a dataset? But I'll try next week. Thanks again!Jag Gutz
November 26th, 2010 1:06pm
You can do it, the way to do it is detailed in the post below
http://road-blogs.blogspot.com/2010/12/conditional-navigation-in-ssrs.html
Please mark this as an answer if this is what you wanted, as I believe the above answer is not correct and it would help other people if you mark this as the answer
Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2010 12:19pm
Using two textboxes in place of one don't really work.
Using the expression as you suggested in the Action Menu (Navigation Tab equiv I guess) worked.
Thanks Jason.Jag Gutz
December 9th, 2010 2:55pm
Hi Jason,
Thank you for point out and correct the answer of the question. The blog you posted provides a comprehensive analysis of using conditional navigation in Reporting Services. And
thanks again for your assistance and contribution.
Regards,
Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2010 9:33pm