Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Not in the period returns blank report

I am new to Crystal - be kind.

Using XI

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.

Lil' help.

Former Member
replied

So if you remove your record selection (select expert) you DO get records...

I'd like for you to go to Report | Selection Formulas | Record

and use this formula:

(IsNull()) OR (Date () < date(1900,01,01))

Let us know how it works out...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question