Subject: Re: Search for null value in Crystal Report
** 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
Sent: Tuesday, November 08, 2011 11:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Search for null value in Crystal Report
**
Kelly,
We see this error when the ODBC connection gets hosed. Really has nothing to
do with the IsNull statement.
We reconfigure the ODBC connection, sometimes have
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
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
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
*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
] 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
*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
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
*.
** **
** **
** **
*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
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
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
@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Friday, November 04, 2011 13:49
To: arslist@ARSLIST.ORG
Subject: Re: Search for null value in Crystal Report
** 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
13 matches
Mail list logo