Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record Selection 1

Status
Not open for further replies.

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.
 
Modify your record selection slightly

(
isnull({PO_BLANKET.STATUS}) OR
{PO_BLANKET.STATUS} <> "X"
)

-lw
 
That was Perfect lw - Thank you.

I tried that but didn't have the parens () around the selection.

Ray
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top