In ssrs, I want to create an expression for the row visibility. But, the expression will contain 2 conditions from different 2 datasets. I have created an expression, but it does not pass in SSRS. The error message is
"The Hidden expression for the tablix ‘Tablix9’ refers to the field ‘launchdate’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case."
Can some one help me to correct it? Thank you.
=iif (monthname(month(today()))= Last(Fields!MonthName.Value, "DealStarts") or (Fields!launchdate.Value, "RowofTrendingVisibility")>=Parameters!StartDate.Value, true, false)