Creating an exclusion (exception) report

[skries]

Crystal 8.5
SQL Database

There are 2 tables 'WorkOrders' & 'TimeCharges'.

I want to show all work order records only when there is no matching record in the timecharges table. Essentially I am trying to display when time has not been applied against a work order.

Linking field is 'wonumber'

 

[pgtek]

Hi
what commom field do you link
you might try a right other join to get the result that does not match your commom field.
example
if you have a order number that matches the time it will not diplay only the ones not matching
thats a right other join

cheers

pg

pgtek

 

[IdoMillet]

1. Outer join on wonumber

2. Record selection criterion:

IsNull({TimeCharges.Time})

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[skries]

Thanks IdoMillet.

That did the trick.