title: How to dynamically define a value as a hyperlink Action in an SSRS report
body: <p>I am using SSRS 2008 R2 in which two reports have been created under the same solution.  I need to know how to disable the hyperlink action for a column value that is equal to 0.  </p>
  
  <p>Of the two reports, one is the default main report and the other is a child that opens and displays records associated with a record from the main form.  This is triggered by a field called Diff.  Right now, all of the values under the Diff column display as a hyperlink, including those that are 0.  But there is no point in providing a hyperlink if the value is 0, as it will just open a child form that does not contain any records.  How do I disable the action of opening another report for where the Diff value = 0?</p>
  
  <p>Using the following expressions in the Text Box Properties / Font tab, I was able to display the Diff value as Black vs Blue, Default vs Underline, and Default vs Bold based on a value of 0.  But I could not find an expression associated with Action.</p>
  
  <pre><code>=IIF(Fields!Diff.Value = 0, "Black", "Blue")
  =IIF(Fields!Diff.Value = 0, "Default", "Underline")
  =IIF(Fields!Diff.Value = 0, "Default", "Bold")
  </code></pre>
  
  <p>Thanks in advance for your help.  I ran searches but could not find a solution to this issue.</p>