>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?
In the File->Report Options check the two boxes that start with Convert database NULL values and Convert other NULL values. You may wish to do the same in the Options menu item as well. Let me know if this works.
HTH,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!