The Algorithm Blog

Crystal Reports Help: Using Not In Logic in Record Selection

Record selection criteria is set in Crystal Reports in the Select Wizard. Users can build a custom record select statement using multiple criteria. By clicking on the Show Formula button, users can see the Select statement.

crystalreports1 resized 600

If an SQL query already exists, users can paste the SQL select statement into the Select Expert Formula window. Here’s an example of a SQL statement pasted into Crystal and cleaned up to conform to Crystal requirements:

crystalreports2

describe the image

However, Crystal does not always honor Microsoft SQL syntax. In this case, here is a SQL select statement:

crystalreports4

The NOT IN SQL syntax will not work in Crystal. It has to look like the example below.

crystalreports5 resized 600

Find More Crystal Reports Tips Here

Subscribe to Our Blog

Recent Posts