I have made a formula in a search that works the way I want but when I attempt to get the same out of a report I fail miserably. :h_a_w::h_a_w::h_a_w:
Is it possible to do similar equations from searches in reports? Let me state that I am no expert at reports and I even try to stay away from them because I feel searches are much easier to deal with.
Here is an example of an formula
CASE WHEN {customermain.custentity2} IS NOT NULL THEN {customermain.custentity2} WHEN {customermain.parent} IS NOT NULL THEN {customermain.parent} ELSE {name} END
it looks for the customer group first, then to see if there is a parent company, and if neither applies, then it goes to the customer name.
If some one could help me get this on a report it would make my life a lot easier. Thanks