Crystal 10 against an Informix database. I have a report grouping purchasing records by the expected delivery date so that the output is grouped by LESS THAN 30 DAYS, 30-60 DAYS, 60-90 DAYS, etc. The expected delivery date is subtracted from the data date to determine which group the record falls into. However, there are actually two different EXPECTED DELIVERY DATES that come into play, one from the purchase order and another one from an expediting record. How, do I select and group each row based on the greater date between these two tables? Also, the expediting record may or may not exist.
Thanks in advance.
Rw.
Thanks in advance.
Rw.