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<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. 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<mailto: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<tel:734.997.4777> kelly.lo...@proquest.com<mailto:kelly.lo...@proquest.com> www.proquest.com<http://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<mailto:arslist@ARSLIST.ORG>] On Behalf Of Jason Miller Sent: Friday, November 04, 2011 2:17 PM To: arslist@ARSLIST.ORG<mailto: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<mailto: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<tel:734.997.4777> kelly.lo...@proquest.com<mailto:kelly.lo...@proquest.com> www.proquest.com<http://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<mailto:arslist@ARSLIST.ORG>] On Behalf Of Jason Miller Sent: Friday, November 04, 2011 1:14 PM To: arslist@ARSLIST.ORG<mailto: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<mailto: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<tel:734.997.4777> kelly.lo...@proquest.com<mailto:kelly.lo...@proquest.com> www.proquest.com<http://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<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://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"
