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

  • Question

  • 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?



    Tuesday, August 6, 2013 12:51 PM