Hopefully an easy question.  I would like to create a Crystal report to show 
currently unassigned tickets, but I am having trouble finding the right format 
to identify tickets where 'Assignee' is null.  Here is what I have tried so far:

IsNull() - This works in Crystal, but Remedy returns no entries.
= "" - This causes an error in Crystal [Database Vendor Code: 300], which I 
can't find any details on.  Note that = "" works fine in an IIf statement I 
have in another report.
= " " - Finds no entries.

I have tried these with the formula editor null treatment set to 'exception' 
and 'default', with no change in results.

I also don't have the standard Remedy reports (most were removed) to see if 
there are any functioning examples of reports that use a check for a null 
value.  Several searches on BMC support also yielded no information on any way 
to search for a null value in a Crystal report.

Is there a functional way to search for a null value in a Crystal Report?

Kelly Logan, Sr. Systems Administrator (Remedy), GMS
ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 
USA | 734.997.4777
kelly.lo...@proquest.com<mailto:kelly.lo...@proquest.com>
www.proquest.com

ProQuest...Start here. 2010 InformationWeek 500 Top Innovator

P Please consider the environment before printing this email.

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the sender, and delete the 
message from your computer.


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Reply via email to