hidden rows

Hi
Hope someone can help.
I'm trying to hide a row based on 2 criteria.
If i use one this =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value,
True, False) it works but as soon as i add another criteria e.g.
=iif(Fields!RespTimeEq.Value > Fields!RespTime.Value and
Fields!VisitType.Value="GSC", True, False) it doesn't work.
Is this possible hide a row based on two criteria and if so what is the
correct syntax for it.
Thanks PaulI would thing that there is something wrong with
Fields!VisitType.Value="GSC", either this is never "GSC" (uppercase,
lowercase) or VisitType is not a string
So perhaps Fields!VisitType.Value.ToUpper()="GSC", would work (?)
"pcalv" wrote:
> Hi
> Hope someone can help.
> I'm trying to hide a row based on 2 criteria.
> If i use one this =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value,
> True, False) it works but as soon as i add another criteria e.g.
> =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value and
> Fields!VisitType.Value="GSC", True, False) it doesn't work.
> Is this possible hide a row based on two criteria and if so what is the
> correct syntax for it.
> Thanks Paul