SSRS 2008 Report - Hide Textbox based on a value in another DataSet

• Question

• 

  

  0

  Sign in to vote

  Hi there. I am trying to hide Textboxes and Tablix's in my report based on values from other DataSets. For example on the first page of the report, 4 Tablix's (DataSets 1-4) are printed. On subsequent pages, Textboxes and other Tablix's (DataSets 5 onwards) are printed but I want to hide/show these based on a field from DataSets 1-4. I sort of have it working but my expression is wrong because some items are still being printed, I think because it has put FIRST in my expression:

  =First(Fields!Expr1.Value, "DataSet2") = "MONITOR: EVENT MONITORING & ALERTING" AND First(Fields!new_SubscribedTo.Value, "DataSet2") = False

  What is the correct expression to use?

  Thanks

  ---

  BM

  Tuesday, August 6, 2013 12:51 PM