Recent content by jscgov

Yes---thank you. I am probably not the first person to not post the full content. I was thinking it may have to go to a case statement. And you can't remove FIELD and VALUE because this is an SSRS expression.

I've been debating putting this in the query. Also, I probably should have added that this is a very long IIF statement---this is the part that isn't working. It's something I am using to group a user license report. =IIf(FIELDS!maximousers.Value >= 1 and IsNothing(FIELDS!UserId.Value)...

I have an IIF statement I am trying to use in a report. 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" This worked great in Crystal (in Crystal...