Hello,
I've got a report created that details open sales orders. Orders are pulled from {co_bln.co_num} If I drop in the field {co_ship.shipdate} then the sales orders that do not have shipments disappear and those with shipments remain. Is there a formula that can be created to keep all the sales orders listed and only put the ship date for those that have shipped? (Crystal 9, SQL)
Example:
SO 1025
SO 2356 Ship Date 05/10/05
SO 2689 Ship Date 05/02/05
SO 3568
SO 3659
Thanks-
Laurie
I've got a report created that details open sales orders. Orders are pulled from {co_bln.co_num} If I drop in the field {co_ship.shipdate} then the sales orders that do not have shipments disappear and those with shipments remain. Is there a formula that can be created to keep all the sales orders listed and only put the ship date for those that have shipped? (Crystal 9, SQL)
Example:
SO 1025
SO 2356 Ship Date 05/10/05
SO 2689 Ship Date 05/02/05
SO 3568
SO 3659
Thanks-
Laurie