I have a formula like this:
if {table1.col1} = "X" and {table1.col2} = {table2.col2} then {table2.col3}
else
if {table1.col1} = "Y" and {table1.col2} = {table3.col2} then
{table3.col3} else
if....the same as above with different tables.
All I am trying to do is to display table2.col3, table3.col3 and so forth to show the desc values and now I put this formula in the report detail field and the report shows no records. The report also has customer id, date and amount and other fields in it and they all go blank. What am I doing wrong in the formula here. Please any help will be appreciated!
IP Logged
