Solved

How to display a bit field value as Yes and No

Posted on 2008-10-20
1
359 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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

17 Experts available now in Live!

Get 1:1 Help Now