Crystal Reports Formula

Posted on 2013-01-16
Medium Priority
Last Modified: 2013-01-16
I have the following working correctly...

if {icitem.item} = "NOTE-" then {sotran.descrip} then {sotran.descrip} else {icitem.itmdes2}

I need the following to it. "{icitem.item} = "CC_APPROVAL"

So if icitem.item = "NOTE-" or  "CC_APPROVAL" then {sotran.descrip} else {icitem.itmdes2} but that is not working.
Question by:jasonspopma
1 Comment
LVL 18

Accepted Solution

vasto earned 2000 total points
ID: 38784574
if icitem.item = "NOTE-" or  icitem.item = "CC_APPROVAL" then {sotran.descrip} else {icitem.itmdes2}

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

600 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