Crystal 8, showing records from another subset on one report

[Taij]

hello
I have to create a report which shows ALL jobs with or without revenue. Jobs which did not get invoiced will not have revenue or a record in the invoice table.

right now, when I link the job table to the invoice table, it will only show me records which have been invoiced. how can i get it to show records which have been invoiced as well as jobs that have not been invoiced? can i do this in one report?

eg
Job No Revenue
a111 $2000
B112 was not invoiced, but should be on report with a value of 0

Thanks much

 

[dgillz]

Create a left outer join from the jobs table to the invoice table.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com