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"