I have a table inside a SSRS report. I have a problem writing the correct expression regarding the visibility condition.
I would like to set a condition that:
IF the column in the dataset contains more than one rows that has "DK1" in fiel valued I would like to show the table.
=iif(Countrows(Fields!DK1_DK2.Value = "DK1") > 1, TRUE, FALSE)
But with the above expression I get the error: The expression has a scope parameter that is not valid for an aggregate function.
Can you help out here?