Hello again, Does the report run fine in CR Developer?
How is the report configured in Remedy? I am assuming it is an attachment in the Report form. Jason On Fri, Nov 4, 2011 at 10:44 AM, Logan, Kelly <kelly.lo...@proquest.com>wrote: > ** > > Curiouser and curiouser – I tried creating a simpler report as you did > with the query of:**** > > ** ** > > IsNull({HPD_Help_Desk.Assignee}) and**** > > {HPD_Help_Desk.Assigned_Group} = "PQ-Infrastructure Engineering"**** > > ** ** > > And got “Unknown Database Connector Error” when I tried to run it from > Remedy.**** > > ** ** > > It is perhaps also worth noting that we are using Remedy User 7.5 patch > 004.**** > > ** ** > > ** ** > > *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**** > > 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*.**** > > ** ** > > ** ** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller > *Sent:* Friday, November 04, 2011 1:14 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Search for null value in Crystal Report**** > > ** ** > > ** Hi Kelly,**** > > ** ** > > ISNULL should to it. I just built a quick report (against Help Desk 6) to > validate using the following query:**** > > ** ** > > {HPD_HelpDesk.Arrival_Time} > CurrentDate -1 and**** > > ISNULL ({HPD_HelpDesk.Assigned_To_Individual_})**** > > ** ** > > Jason**** > > ** ** > > On Fri, Nov 4, 2011 at 8:37 AM, Logan, Kelly <kelly.lo...@proquest.com> > wrote:**** > > ** **** > > 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**** > > 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*.**** > > **** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > ** ** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"