Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Using Crystal 9 and need to convert field values to a text equivalent

Posted on 2003-02-21
Medium Priority
Last Modified: 2010-04-17
I have created a report in Crystal which obtains data from an Access database.  I have a field called status which holds the
values 0 which should display as "Active"
       1 which should display as "Inactive"
       2 which should display as "Left"

I do not know Crystal well at all and am on a steep learning curve.  Any help and advise on how to get the report to display the correct text based on the status value?

Question by:Littleone

Accepted Solution

massDer earned 150 total points
ID: 7994644
The Easiest way to do this would be to create a formula field. Click on the formula workshop icon (looks like x-1).
Click New Formula (dont accidently create a new function).
Name the formula and then click on it in the left pane.

type this as the formula:

if whatevertablename.status = 0 then
else if whatevertablename.status = 1 then

replace whatevertablename with the name of your access database table.

Author Comment

ID: 8032494
Thank you for your response this worked a treat

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
No other job is as rewarding and demanding as building an iPhone app is. It is not really in the hands of the developer for the success of an iPhone app. Many factors operate jointly for every iOS application's success in the market.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Loops Section Overview

577 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