Tim Ragan
asked on
How do I print a text string based on a field value #1 set to True or print the contents of another field #2 if field #1 is False or Null?
Crystal Reports Version 8.5
Backend is SQL Server
First, I'm using this old version of Crystal to modify a document bundled in a application that uses the older version. Modifying the document with a newer version is not viable.
I have a check box option on the user sales order screen that is null when the sales order is created. If there is a credit concern the user can click a check box on a field labeled "Check Balance" and save. I need this action to result in the "Check Balance" string to print on the order form. If the check box value has never been checked it remains null. If the check box is checked, saved, and later unchecked, and saved the value is updated to False. If the check box value is Null or False I need the conditional print of values from a list of settable values. I don't have a problem getting the "Check Balance" to print and have had the formula working properly when the Check Balance field is null. My problem shows up when the field is checked/unchecked causing the field value to update to False. No doubt its simple for the experts here but I've made a number of passes and need direction.
This formula works as long as {SalesOrderAcknowledgment. ORDERS.O.U SER_4} is True or Null. When {SalesOrderAcknowledgment. ORDERS.O.U SER_4} = False I get no print.
if {SalesOrderAcknowledgment. ORDERS.O.T ERMS_RULE_ ID}="CIA" THEN "CASH IN ADVANCE"
ELSE IF {SalesOrderAcknowledgment. ORDERS.O.T ERMS_RULE_ ID}="CASHI ERS CHK" THEN "CASHIERS CHECK"
ELSE if {SalesOrderAcknowledgment. ORDERS.O.T ERMS_RULE_ ID}= "COD" then "COD" else if {SalesOrderAcknowledgment. ORDERS.O.U SER_4} = "True" then "Check Balance"
{SalesOrderAcknowledgment. ORDERS.O.T ERMS_RULE_ ID} will always have a value. I want the text string shown to print as selected by the user or Check Balance if {SalesOrderAcknowledgment. ORDERS.O.U SER_4} = True
Report file attached.
SalesOrderAcknowledgement.rpt
Backend is SQL Server
First, I'm using this old version of Crystal to modify a document bundled in a application that uses the older version. Modifying the document with a newer version is not viable.
I have a check box option on the user sales order screen that is null when the sales order is created. If there is a credit concern the user can click a check box on a field labeled "Check Balance" and save. I need this action to result in the "Check Balance" string to print on the order form. If the check box value has never been checked it remains null. If the check box is checked, saved, and later unchecked, and saved the value is updated to False. If the check box value is Null or False I need the conditional print of values from a list of settable values. I don't have a problem getting the "Check Balance" to print and have had the formula working properly when the Check Balance field is null. My problem shows up when the field is checked/unchecked causing the field value to update to False. No doubt its simple for the experts here but I've made a number of passes and need direction.
This formula works as long as {SalesOrderAcknowledgment.
if {SalesOrderAcknowledgment.
ELSE IF {SalesOrderAcknowledgment.
ELSE if {SalesOrderAcknowledgment.
{SalesOrderAcknowledgment.
Report file attached.
SalesOrderAcknowledgement.rpt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER