Print Page | Close Window

Case formula issues

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=21615
Printed Date: 25 Apr 2024 at 3:13pm


Topic: Case formula issues
Posted By: dfolzenlogen
Subject: Case formula issues
Date Posted: 26 Jul 2015 at 4:22am
I'm using the following formula:

Select {CCE_WPX.Status}
    case “Active Injector” : “AI”
    case “Producing Oil Well” : “PO”
    case “Producing Gas Well” : “PG”
    Default : "VERIFY"

but get the following error message:

"A number, currency amount, boolean, date, time, date-time, or string is expected here.

I'm not sure where I'm going wrong as I have used this format previously.

Thanks.


Replies:
Posted By: kevlray
Date Posted: 27 Jul 2015 at 4:28am
You didn't copy the code from a text editor did you?  If so, sometimes the quotes they use are not what CR recognizes.


Print Page | Close Window