Linked Table Problem 1

[mfroggie]

I hope someone can point me in the right direction. I am trying to write a report where I need information out of one table and just 1 field out of another table. The tables have common key fields ie vendor number. When I start adding my fields just to get my innitial data whenever I add the one field from the 2nd table the only invoices that show up are invoices with 0.00 balance. I haven't put a report selection or anything in. If I delete that field then all the invoices show up again. I just want to be able to group by that field to get a total of outstanding invoices why does it make all the invoices with outstanding amounts go away? Thanks in advance

Mfroggie

 

[lyanch]

You need to place an outer join. There apparantly is no data for the items in your first table for some of the records in the second.

Assuming your link is first (lots of fields) to second (one field) in the visual linking expert, right click on the link and select options. Change the link to left outer join.

That should do it.

Lisa

 

[mfroggie]

Thanks, there were some other links between the 2 tables and I deleted all but for the first one and then did what you said with that link and it worked. Thanks for the help. Mfroggie

 

[kenhamady]

Keep in mind that you can't add any criteria using fields from this "outer" table, or else you will be limited to records with matches, as you were before. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com