TimmieLynn
MIS
Crystal XI SP1, ODBC. I have a report that displays a company's address in the page header. This info is pulled by using the following formula:
IF {Customer_Master.NAME_23}={SO_Master.NAME_27} and {Customer_Master.ADDR1_23}={SO_Master.ADDR1_27} and {Customer_Master.ADDR2_23}={SO_Master.ADDR2_27} and {Customer_Master.CITY_23}={SO_Master.CITY_27}
THEN {Customer_Master.ADDR2_23}
// test if the ship-to is a subcontractor
ELSE IF "NAMEEXAMPLE" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE IF "NAMEEXAMPLE3" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE IF "NAMEEXAMPLE2" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE {SO_Master.ADDR2_27}
The name and address displays correctly on page 1 but not on any of the following pages.
IF {Customer_Master.NAME_23}={SO_Master.NAME_27} and {Customer_Master.ADDR1_23}={SO_Master.ADDR1_27} and {Customer_Master.ADDR2_23}={SO_Master.ADDR2_27} and {Customer_Master.CITY_23}={SO_Master.CITY_27}
THEN {Customer_Master.ADDR2_23}
// test if the ship-to is a subcontractor
ELSE IF "NAMEEXAMPLE" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE IF "NAMEEXAMPLE3" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE IF "NAMEEXAMPLE2" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE {SO_Master.ADDR2_27}
The name and address displays correctly on page 1 but not on any of the following pages.