SQL Reporting Checkbox

Posted on 2006-04-27
Last Modified: 2008-03-17
Hi All---

Quick question I'm surprised that I couldn't easily find an answer for...  Creating a report in SQL reporting from a SQL DB.  DB has some bit fields (0,1) that I'd like to display on my report as a checkbox.  The query in SQL Reporting interprets these fields as True/False which I assume is fine--but wants to display it as a text field only.  Is there a way to write an expression or change the format so that this field will show on the report as a checkbox?  Or barring that, how 'bout changing the output to something a little more user friendly like  True = "Completed", False = "Not Completed".

Thanks for your help...  P.S.--going out of town on a fishing trip this weekend so I won't be  able to immediately respond but rest assured I won't leave you hanging!

Question by:rz1224
    LVL 14

    Accepted Solution

    Quickest way I found was to use a font like Webdings or Wingdings, where there are check and cross characters.  Find the characters that show what you need and then use an expression in your textbox using somthing like =IIF(MyField.Value=1,"t","h")

    Author Comment

    Thank you Simon--That'll work!

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    How to increase the row limit in Jasper Server.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    746 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

    18 Experts available now in Live!

    Get 1:1 Help Now