Have you tried on different computers? I am wondering if it is an ODBC issue/setting?
On Fri, Nov 4, 2011 at 12:32 PM, Logan, Kelly <kelly.lo...@proquest.com>wrote: > ** > > No. :^)**** > > ** ** > > ** ** > > *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 3:31 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Search for null value in Crystal Report**** > > ** ** > > ** Hmmm. I was thinking it may have already been set to Yes. Does the > error go away when setting it to Yes?**** > > On Fri, Nov 4, 2011 at 12:15 PM, Logan, Kelly <kelly.lo...@proquest.com> > wrote:**** > > ** **** > > The ‘Override Query in Report’ field is set to “No”, but setting it to > “Yes” overrides the query in the report so that none of the parameters in > the report are used. So I have the original parameters (other than the > Assignee check) in the Crystal report and the ‘Assignee’ check in the > report ‘Base Qualification’.**** > > **** > > **** > > *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 3:10 PM**** > > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Search for null value in Crystal Report**** > > **** > > ** No problem at all.**** > > **** > > In the Report record is "Override Query in Report" set to No? Do you need > to be able to specify the query from Remedy or will the query be controlled > completely by Crystal?**** > > **** > > We had some broken (web) reports in the last few months with the query > embedded in the reports. We had to change it from Yes to No before the > reports would start working again. I think when these reports were build > way back in the 6.x days the Override Query in Reports option behaved a > little differently and nobody noticed/reported they broke somewhere along > the line from 6.x -> 7.0 -> 7.1 -> 7.5.**** > > **** > > Jason**** > > **** > > On Fri, Nov 4, 2011 at 11:43 AM, Logan, Kelly <kelly.lo...@proquest.com> > wrote:**** > > ** **** > > Hello Jason, and thanks for working with me on this. :^)**** > > **** > > The report runs in CR Developer (version 11.0.0.1282), and is attached to > the ‘Report’ form. I have also confirmed that the same report without the > IsNull() statement (replaced with ‘Status’ = “Assigned” for testing) works > fine, so it’s not the ‘Report’ entry or something else in the report file > itself.**** > > **** > > In the meantime, I’m using a workaround by setting the ‘Base > Qualification’ for the report entry to:**** > > 'Assignee+' = $\NULL$**** > > **** > > **** > > *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 2:17 PM**** > > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Search for null value in Crystal Report**** > > **** > > ** 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"_ **** > > **** > > _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"_ **** > > _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"