I just completed a huge project which involved showing hits where related records did not exist and I too utilized the ISNULL function with various amounts of success in Crystal.  I found it easier to replace the NULL values in one formula and then call that formula later.  Example:  X =  IF ISNULL(value) then 0 else value.  Once this was done, I used X everywhere I would have used the value.
Â
I found that in some cases, it was easier to use the a Calc field in the BAQ to get around using the ISNULL statement in Crystal.  Date Values were the worst.  For those, I took a date field which always existed and added or subtracted enough days to provide relationships that I knew would fail when doing comparisons.
Â
Just be careful.  A null is not the same as a blank which is not the same as a space character which is not the same as a zero.  One dead give-away on your report is when formula results show up as white space on your previewed report when you were expecting a zero.
Â
Example:Â Â Show the difference in days between an expected Due Date for a Purchase Order and the Receipt Date.
Â
Due         Receipt        Result
2/1/08Â Â Â Â Â 2/2/08Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 1
2/1/08Â Â Â Â Â (no record)
2/1/08Â Â Â Â Â 2/1/08Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 0
Â
I hope this helps,
GlenÂ
Â
I found that in some cases, it was easier to use the a Calc field in the BAQ to get around using the ISNULL statement in Crystal.  Date Values were the worst.  For those, I took a date field which always existed and added or subtracted enough days to provide relationships that I knew would fail when doing comparisons.
Â
Just be careful.  A null is not the same as a blank which is not the same as a space character which is not the same as a zero.  One dead give-away on your report is when formula results show up as white space on your previewed report when you were expecting a zero.
Â
Example:Â Â Show the difference in days between an expected Due Date for a Purchase Order and the Receipt Date.
Â
Due         Receipt        Result
2/1/08Â Â Â Â Â 2/2/08Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 1
2/1/08Â Â Â Â Â (no record)
2/1/08Â Â Â Â Â 2/1/08Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 0
Â
I hope this helps,
GlenÂ
--- On Wed, 9/10/08, Late, Travis <tlate@...> wrote:
From: Late, Travis <tlate@...>
Subject: [Vantage] Crystal and using Null values
To: vantage@yahoogroups.com
Date: Wednesday, September 10, 2008, 11:25 AM
I'm trying to create a report that shows Jobs with no print date. Does
anyone know the formula that I will use to get this to display
correctly. I'm using fields in the JobHead. I know the field that
requires the formula will be TravelerLastPrinted . Does anyone know how
to use the isnull function for this or should I be using something else?
Thanks,
Travis Late
ERP Project Manager
M-B Companies, Inc
1200 Park Street
Chilton, WI 53014
Phone: 920-898-1560 Ext.152
Cell: 920-960-0062
Email: tlate@m-bco. com <mailto:tlate@m-bco. com>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]