YANKRAY
Technical User
- Nov 7, 2003
- 283
CR 10.0
I have a Crystal Report where I pull information about Parts billed to a customer.
Some of the parts have Purchase Orders while others do not.
The data is in 6 different tables and there is no grouping.
When I added in the Purchase Order Number (using a Left Outer Join), I received some duplicate lines with different Purchase Order Numbers. This was because the Original Purchase Order was canceled and a new one issued. This was a valid result.
The problem is when I try to remove those Purchase Orders with a Status of X (for canceled). When I include the record selection of {PO_BLANKET.STATUS} <> "X" I only get a result of the lines with a Purchase Order Number and I lose the NUll values Purchase Order number lines.
How do I select the records that do not have a canceled status but keep all the recoreds with a NUll value.
I have a Crystal Report where I pull information about Parts billed to a customer.
Some of the parts have Purchase Orders while others do not.
The data is in 6 different tables and there is no grouping.
When I added in the Purchase Order Number (using a Left Outer Join), I received some duplicate lines with different Purchase Order Numbers. This was because the Original Purchase Order was canceled and a new one issued. This was a valid result.
The problem is when I try to remove those Purchase Orders with a Status of X (for canceled). When I include the record selection of {PO_BLANKET.STATUS} <> "X" I only get a result of the lines with a Purchase Order Number and I lose the NUll values Purchase Order number lines.
How do I select the records that do not have a canceled status but keep all the recoreds with a NUll value.