• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

Change True/False to Active/Not Active

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!
0
nsehmi
Asked:
nsehmi
  • 2
1 Solution
 
chapmandewCommented:
select case punchedin when 1 then 'Yes' when 0 then 'No' End, *
from tablename
0
 
nsehmiAuthor Commented:
How would you add that in reporting services.
0
 
jgvCommented:
You've got the right idea but you don't need to use true or false; just use the text you want displayed in the cell:
=IIF(Fields!Punch.Value = 1, "Yes", "No")
0
 
nsehmiAuthor Commented:
I forgot about the quotations. THANK YOU !!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now