Solved

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

Posted on 2008-10-27
2
1,908 Views
Last Modified: 2012-05-05
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
Comment
Question by:expertsexchangehunter
2 Comments
 
LVL 12

Accepted Solution

by:
jgv earned 500 total points
ID: 22822198
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
 

Author Closing Comment

by:expertsexchangehunter
ID: 31510548
Ok. That works. <> 0 also worked
Thanks
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now