I have an IIF statement I am trying to use in a report.
It reads:
This worked great in Crystal (in Crystal format), but isn't working in SSRS. No matter how I assemble this statement, it seems to ignore the No Groups Value and returns a list of all the users in the system who are active. I've tried everything. Does anyone have a clue? :banghead:
It reads:
IIF( (FIELDS!NOGROUPS.Value =1 and FIELDS!maximousers.Value = 1 and FIELDS!UserStatus.Value = "ACTIVE") ,
"2 - Only in default groups - May need ticket to Sys Admins to remove"
"2 - Only in default groups - May need ticket to Sys Admins to remove"
This worked great in Crystal (in Crystal format), but isn't working in SSRS. No matter how I assemble this statement, it seems to ignore the No Groups Value and returns a list of all the users in the system who are active. I've tried everything. Does anyone have a clue? :banghead: