When I look in Crystal Report it is there. Also, this report works in the user tool as designed (with the external field) but not in the web.
________________________________ From: [email protected] santana [mailto:[email protected]] Sent: Thursday, March 10, 2011 8:37 PM To: [email protected] Cc: Pargeter, Christie :CO IS Subject: Re: Issue with a report Did you check to make sure that this field 'ARSYS_SERIAL_QUAL_COLUMN' is on the form NTE_Notifier_Log? Kimberly On 3/10/2011 7:24 PM, Pargeter, Christie :CO IS wrote: ** I am trying to build a report against the NTE:Notifier Log screen and if I put any quals on the Active Link I get This field name is not known. Details: errorKind Error in File C:\WINDOWS\TEMP\CLUserHistory {200BA716-D86C-4D45-9F30-0913A657F293}.rpt: Error in formula . '{NTE_Notifier_Log.ARSYS_SERIAL_QUAL_COLUMN} <> "4\3\1\3\2\7\1299744000\"' This field name is not known. Details: errorKind This has ('Submit Date' >= $Start Date$) as the qual. But if I leave quals empty on the Active Link the report will run. Eventually, I want to use a External qual on this report. I thought I had this running a couple of months ago but just tested it again and now it is broken. ARS 7.1 p 6 ITSM 7.0.3 p 9 Window 2003 MS SQ 2005 IIS/Tomcat RKM 7.2 p 4 MidTier 7.5 p 7 ________________________________ Christie Pargeter Legacy Health IS - Programming SR Technical Analyst [email protected] 1120 Building tel: 503-415-5149 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
