tags:

views:

25

answers:

1
Q: 

I need to convert a returned number in a report with text?

I have a value in a report that is returned as a number for example 1 - What i am trying to do is whenever 1 is displayed in the report i want it to show text such as Program Live.

I am using crystal 9, any help would be appreciated.

A: 

Create a crystal formula and use this code:

if {numeric var} = 1 then
    "Program Live"
else
    ""

You can then place the formula on your report. Hope this helps. Wade

Wade73  2009-11-24 16:41:45

related questions

Is there a VB.NET function to format a number as an Ordinal
Defining different types of numbers in C#
Replace non-numeric with empty string
.Net Converting a number from one culture to another
Need a simple RegEx to find a number in a single word
How do I round a number in javascript?
random number with ratio 1:2
How to count unique records and get number of these uniques in table using SQL?
Is there a difference between is_int() and ctype_digit()?
Parse Phone Number into component parts
How to get the Nth digit of an integer with bit-wise operations?
Unique random numbers in O(1)?
What is the best way to validate a credit card in PHP?
String to Int in java - Likely bad data, need to avoid exceptions.
How can I convert a number to its multiple form in Perl?
How to convert floats to human-readable fractions?
Single most effective practice to prevent arithmetic overflow and underflow
Determine if a string is an integer or a float in ANSI C
How to read values from numbers written as words?
Octal number literals: when? why? ever?
Searching for phone numbers in mysql
Validate numbers in JavaScript - IsNumeric()
How do I tell if a variable has a numeric value in Perl?
SQL, Auxiliary table of numbers
Most efficient code for the first 10000 prime numbers?