How are you connecting to the data? Direct access or ODBC?
>Hi all,
>
>I am working on a report in Crystal Reports v9 looking for inventory items in a VFP free table where the item status is 'out', but there is no date for when the item went out. Of course the table has a blank and Crystal returns no records when I set the criteria to be {table.field} = {0,0,0}. However there are way too many items that do not have an out date. How can I get Crystal to see the blank fields in FoxPro and give me the data that I want?
>
>I've played with formulas, IsNull, convert null in options and report options to no avail. Craig--you're the master, what is the path to enlightenment?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer