Not in the period returns blank report
I am new to Crystal - be kind.
Database is on SQL 2000
Creating a report of items checked out and not returned. The return date in the data base is <Null> if item is out. I tried using a formula: IsNull() but get a blank report when I know there are at least 180 items out.
When I go to SQL and run a query it works fine.
I also tried using "is not in the periord - AllDatesToToday" and get a blank report.