Formula help - suppress Description

[TechUser23]

My current formula:

stringVar sProcedureDescription := LEFT({ParadigmReceipt.Description}, 200);

IF NOT ISNULL({ParadigmReceipt.CPTCode}) THEN
sProcedureDescription := sProcedureDescription + " (" + {ParadigmReceipt.CPTCode};

IF NOT ISNULL({ParadigmReceipt.CPTCode}) AND NOT ISNULL({ParadigmReceipt.Modifier1}) THEN
sProcedureDescription := sProcedureDescription + " " + {ParadigmReceipt.Modifier1};
IF NOT ISNULL({ParadigmReceipt.CPTCode}) AND NOT ISNULL({ParadigmReceipt.Modifier2}) THEN
sProcedureDescription := sProcedureDescription + "," + {ParadigmReceipt.Modifier2};
IF NOT ISNULL({ParadigmReceipt.CPTCode}) AND NOT ISNULL({ParadigmReceipt.Modifier3}) THEN
sProcedureDescription := sProcedureDescription + "," + {ParadigmReceipt.Modifier3};
IF NOT ISNULL({ParadigmReceipt.CPTCode}) AND NOT ISNULL({ParadigmReceipt.Modifier4}) THEN
sProcedureDescription := sProcedureDescription + "," + {ParadigmReceipt.Modifier4};

IF NOT ISNULL({ParadigmReceipt.CPTCode}) THEN
sProcedureDescription := sProcedureDescription + ")";

sProcedureDescription

What my client needs is to suppress the description within this current formula. Im not a crystal report writer, so Im asking someone here for help.

 

[lbass]

The desscription is the formula's result, so it's unclear what you want to do. Maybe you should show the results you are getting and then the results you want to get.

-LB

 

[hilfy]

By "suppress the description" do you mean the description field that's used at the beginning of the formula? If so, that's fairly simple. Change the first line to:

stringVar sProcedureDescription := "";

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.