Crystal report if then help, how to return a string or variable with formula

if-statement crystal-reports-2010
Col.Forbin picture Col.Forbin · Oct 30, 2013 · Viewed 18.4k times · Source

Relatively new to crystal and I've hit a bit of a snag with a formula.

I'm trying to create a formula that will report out when an RMA was received and how many. If none of the items have been received, I want it to show a message stating such, but if items from the RMA have been received I want it to return the receipt number.

Since a picture is worth a thousands words...

Current report view

I tried using an if then but I don't think you can combine strings with BAQReportResult values.

if {BAQReportResult.RMARcpt.OurReceivedQty}>0 then {BAQReportResult.RMARcpt.RMAReceipt}

After that I tried a variety of else statements but stuck here I am...

Any help is greatly appreciated!

Answer

JulyOrdinary picture JulyOrdinary · Nov 6, 2013

I think you must declare a string type and then assign the value in else part.

Create a Formula and place in the Report, what has to be written in formula will be like:

stringvar text:="";
if {BAQReportResult.RMARcpt.OurReceivedQty}>0 then 
text="{BAQReportResult.RMARcpt.RMAReceipt}"
else
text="There are ..."

Related questions

How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
Python's equivalent of && (logical-and) in an if-statement

Here's my code: def front_back(a, b): # +++your code here+++ if len(a) % 2 == 0 && len(b) % 2 == 0: return a[:(len(a)/2)] + b[:(len(b)/2)] + a[(len(a)/2):] + b[(len(b)/2):] else: #todo! Not yet done. :P return I'm getting …

Read More
&& (AND) and || (OR) in IF statements

I have the following code: if(!partialHits.get(req_nr).containsKey(z) || partialHits.get(req_nr).get(z) < tmpmap.get(z)){ partialHits.get(z).put(z, tmpmap.get(z)); } where partialHits is a HashMap. What will happen if the …

Read More