Change True/False to Active/Not Active
Posted on 2008-06-25
This is a reporting services question.
I have a field called PunchedIn as 1 or 0. When i use reporting services and show that, it shows 1 or 0. Now, i want to change that to Yes if it shows 1 or No if it shows 0 when reporting it. I dont want to change it in the database.
I tried the IFF command
IFF(Fields!Punch.Value =1, TRUE,FALSE)
and it gives me True and False but i cant change it for it to say Punched In , Not Punched in.
Please tell me how i can do this in reporting services. I am learning it so if you could be a bit more detailed i will apprecaite it!