Specifically, the form is for our shipping department and the title of the form itself determines quite a few fields.
The title is determined by reading the detailed transaction type of the first line in a contract.
Unfortunately, there are numerous contracts that have a different type of record that does not have a transaction type so the form title reads what the else statement says, which is incorrect.
Here's the original code that determines the title of each form.
if {RO_21CrystalContractLineWrk.TransDetailRecordType}="R" then "Receiver"
else "Shipper"
How can I change it so that I can accommodate for situations where if the transaction detail record type is blank, skip the record and move to the next record?
I tried the following but it gives me the next record number, which is correct but I want to evaluate that next record number using an if else.
if {RO_21CrystalContractLineWrk.TransDetailRecordType}="" then next({RO_21CrystalContractLineWrk.ReportLineNumber})
else if {RO_21CrystalContractLineWrk.TransDetailRecordType}="R" then "Receiver"
else "Shipper"
Edited by Ming801 - 18 Sep 2017 at 5:16am
