Solved

How to display a bit field value as Yes and No

Posted on 2008-10-20
1
361 Views
Last Modified: 2008-10-20
I have a report that currently displays a field using a bit value as True and False, It now is required to display as Yea and No. The report gets its data from a Stored Procedure. Where and what is the change required  to make the report display?
Thanks
0
Comment
Question by:expertsexchangehunter
1 Comment
 
LVL 12

Accepted Solution

by:
jgv earned 500 total points
ID: 22760722
This expression is one way to show Yes/No assuming that the underlying value in the dataset field is 0 or 1:
=IIF(Fields!MyBitField.Value = 1, "Yes", "No")
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

803 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