Hello folks,
I have a strange problem that keeps appearing with the crystal reports I'm writing.

My problem is that some fields return blank when the reports are run. At first, i found that it was happening when I used
formulas based on data (I.e a formula that is designed to ALWAYS return something returns no data at all e.g select case
with default case)
This was annoying enough.

But now, I've got a report which uses data from two separate databases (One is SQL, the other is a local access file)
and, even though the linking fields match exactly, the data drawn from the local access file is only sometimes displayed.

The tables are linked by postcode. The access database just has two fields: postcode and Objective area.
When you look up a postcode, you get which objective area its in - it should be that simple.
Theres no hidden whitespace at the end of either postcode field, and I've also turned on the 'Allow partial text matches' option
in the link options.

Can anyone help me work out why crystal reports keeps returning blank data for formulas and for this linked database data?

Thanks for your help folks

Mat