I have a list of subreports in an SSRS report which all have a parameter of Client_No based from their original report. I then only want the subreport to show if the Client No in a dataset 'Summary' has that particular subreport set to 1. The fields of those subreports whether 1 or 0 is bit so I'm not sure if that's the problem but at the moment if I add the following code, it hides this particular subreport even if its set to 1 or 0 when it should only be visible if set to 1 for that particular client and subreport. Basically, different clients only want to see certain subreports.
=IIf(Parameters!Client_No.Value = Fields!Client.Value,"Summary" AND fields!Output.Value,"Summary" = "1!, False, TRUE)
