I've created a simple if-then-else formula (am using CR 8.5) as follows:
if {query.co_owner} = ""
then {query.owner}
else {query.co_owner}
The purpose of this formula is to return the owner's name only if there is no co-owner.
The formula correctly returns the co-owner's name, but will not return the owner's name. When I run my query, I can see both fields. I can put both fields on my report and see the applicable data. The only problem I'm having is with this selective formula.
Anyone know why? Thanks!
if {query.co_owner} = ""
then {query.owner}
else {query.co_owner}
The purpose of this formula is to return the owner's name only if there is no co-owner.
The formula correctly returns the co-owner's name, but will not return the owner's name. When I run my query, I can see both fields. I can put both fields on my report and see the applicable data. The only problem I'm having is with this selective formula.
Anyone know why? Thanks!