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"_
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
