For the visibility of some fields, i want to check if a field has a specific value.
Right now i'm using this visibility expression:
=IIF (Sum(IIF(Fields!TagName.Value = "Option1" , Fields!Val.Value, 0), "ParamDataset") > 0, true, false)
If option1 is 1, the field is shown, if its 0 then its hidden.
Its working, but the solution is bad. It checks all the entrys of Option1, and if it were at one time 1, the field is shown, even if the last entry is 0. Also it differentiates only between 0 and 1.
I'm searching for a expression which checks only the last entry of "Option1", and if possible also if the value is a specific value, not only 0 or 1. For example if its 23 or whatever.
PS: i cannot use tablix and the corresponding filters, because the process data is in a different dataset than the configuration data.