Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2453
  • Last Modified:

How do I get reporting services to recognize a bit field?

I am returning a  bit value field from a Stored Procedue to the report and using the expression
=IIF(Fields!MyBitField.Value = 1, "Yes", "No")
and the report displays no for both 0 and 1
How do I get the report to recognize the value?
0
expertsexchangehunter
Asked:
expertsexchangehunter
1 Solution
 
jgvCommented:
Haven't worked with bit fields in SSRS yet but would have thought it would return 0 or 1. Turns out it shows True/False. Try modifying the IIF statement like this and post back if it doesn't work as expected:
=IIF(Fields!MyBitField.Value = True, "Yes", "No")
0
 
expertsexchangehunterAuthor Commented:
Ok. That works. <> 0 also worked
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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