Nate Neufeld (5/19/2009)
kabolick (1/20/2009)
When there is a value, I want the hyperlink action to be enabled, if there is not a value I want to disable the hyperlink action so that the user doesn't click to a report that has no data.Using the following construct as an expression in Jump To Report works for me:
=IIF(Sum(Fields!CellValue.Value) Is Nothing,Nothing,"Detail Report")
This way the hyperlink cursor never shows on mouseover for a blank cell; it has the effect of disabling any Action.
I was just about to whinge about that RS does not have this feature. NOTHING is what will save you...
Thanks for the tip. The trick with the hiding unhiding overlapping cells, as someoe suggested, brought me troubles in the end with export to PDF/EXCEL. It won't render the same as into HTML, which made me remove the feature. I almost said to the customers that it is not possible to remove 'empty click', before I saw your post. I will try it tomorrow and we will see if it works.
Thanks anyways.
VAL
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM