Hello all,
My report needs to get information from 1 of 2 tables depending on a specific value. Whenever i place that second table into the else statement all i get is a blank report, except for my text objects. It just will not run with a table selection in my formula. Anyway here is my formula:
I would think that Crystal would do this with no problem, but possibly my formula is incorrect, I am not sure.
Any help, as always, is greatly appreciated.
Brian
My report needs to get information from 1 of 2 tables depending on a specific value. Whenever i place that second table into the else statement all i get is a blank report, except for my text objects. It just will not run with a table selection in my formula. Anyway here is my formula:
Code:
if {BillingMaster.Type} = "Long Term" then
{LongTerm.LoanAmount}
Else
{ShortTerm.LoanAmount}
I would think that Crystal would do this with no problem, but possibly my formula is incorrect, I am not sure.
Any help, as always, is greatly appreciated.
Brian