dmreporter
MIS
Using Crystal Reports v8.5, I have two different field values that need to be displayed under one Net Sales column/field.
Specifically, I have one field that contains company sales (e.g.: tbl1.compsalesfield)and another field that contains franchise sales (e.g.: tbl2.frsalesfield). If I want to display either sales values from the mentioned tables under one column (into one 'Net Sales' field), I assume in order to display either value from either tbl1 or tbl2 into one column/field, I'd have to insert a new field object that is defined as a formula field?
If so what should my formula be? I'm not very familiar with Crystal Report syntax and not sure how to construct such a formula.
Any suggestions would be greatly appreciated!!
Specifically, I have one field that contains company sales (e.g.: tbl1.compsalesfield)and another field that contains franchise sales (e.g.: tbl2.frsalesfield). If I want to display either sales values from the mentioned tables under one column (into one 'Net Sales' field), I assume in order to display either value from either tbl1 or tbl2 into one column/field, I'd have to insert a new field object that is defined as a formula field?
If so what should my formula be? I'm not very familiar with Crystal Report syntax and not sure how to construct such a formula.
Any suggestions would be greatly appreciated!!