Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

NULL usage in crystal reports formula/query

Posted on 2008-11-06
1
Medium Priority
?
508 Views
Last Modified: 2012-05-05
Hi

I am using the version of Crystal reports that comes with VS 2005.

I have simple report that I whish to extract information out of the database with.
All works well except where the value of one of the criteria fields is NULL.

My Record selection formula looks something like this
{UpdIND} <> "D" and
{Code} = {?p_Code} and
(({Feld1} < {?Tmp} ) OR {isnull("Field1})))

Basically I want the data where field1 is less than the required value or field1 is null.

When I try to use the "Field1 IS NULL" syntax, crystal rejects it as if the "IS NULL" portion should not be there.
What is the correct way to do this?

tcss
0
Comment
Question by:tcss
1 Comment
 
LVL 1

Accepted Solution

by:
tcss earned 0 total points
ID: 22894034
Solved

Reference from
http://www.isinc.com/2008/10/10/record-selection-and-the-null-value-bug-in-crystal-reports/

Th null part of the expression must come first.
Strange but it worked.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Integration Management Part 2
Loops Section Overview

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question