I want to pull data from two tables into a Crystal Report. They share one field: EmplName. Currently, they are left outer joined by that field (inner join returns no records at all).
When I run the report, I get none of the records from the second table. From the first table, the fields that are numbers populate the report, but not fields of other types, including EmplName.
We have many reports that link more than one table that work correctly, and I am not seeing what is different about this one? Any ideas?