Adding formula field is suppressing entire records

I'm trying to add a value to my report using an sql expression, or also tried using a database field. Some of the records on the report will have a match, and some will not. I want it to display this value where there is a match. Problem is, w开发者_StackOverflow中文版hen I add this formula or database field, the entire row gets suppressed. How can I fix this? Can anyone provide some guidance on this issue?

---

The problem is that all links in Crystal Reports are inner joins by default. In this case, where only some records have a match, you need to use a left outer join so as not to null non-matching records.

http://forums.blackbaud.com/forums/t/8825.aspx