Alternate value display
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19060
Printed Date: 02 May 2024 at 9:04am
Topic: Alternate value display
Posted By: Beebt77
Subject: Alternate value display
Date Posted: 07 Feb 2013 at 9:11am
|
Hello All,
I am hoping that someone can help me, I am trying to create a formula for an item in a table to display with an alternate name/value.
Example in the table the data is identified with numbers such as 3 and 5, and I would like 3 to equal yes and 5 to equal No.
If I want to select all "yes" data, and the return not read the number 3; where and how do I put the formula for 3 to display as yes.
Thanks
 |
Replies:
Posted By: hilfy
Date Posted: 07 Feb 2013 at 11:42am
|
Create a formula for the field. It will look something like this: If {myTable.myField} = 3 then 'Yes' else if {myTable.myField} = 5 then 'No' Then use the formula on your report instead of the field. -Dell
------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |