conceptdata
asked on
SSRS Filter on empty Field
Hi
I have a SSRS report, where i would like to put a filter that shows empty records with empty value in a specific field.
But I can't get it to work.
I have tried :
- iif(IsNothing(Fields!SAL ESREP.Valu e), True, False)
- Fields!SALESREP.Value = ""
I cant get it to work.
I sql management studio the field is showed like this :
I have a SSRS report, where i would like to put a filter that shows empty records with empty value in a specific field.
But I can't get it to work.
I have tried :
- iif(IsNothing(Fields!SAL
- Fields!SALESREP.Value = ""
I cant get it to work.
I sql management studio the field is showed like this :
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi
That was a special character : Chr(2)
So it is solved.
Thanks
That was a special character : Chr(2)
So it is solved.
Thanks
I don't know, for example, where you are trying your code, or what your SQL code is.