There are no errors in Crystal Reports or the User Tool when I try the report only on the web. I did try recreating at one point to use the underscores incase that was the issue. But the really odd point to me is that if I run the report with any quals it works but if I add '3'>="1/1/11" I get the error. I tried to add the report to the Reporting Console and to select the Submit Date and just that field and I still get the error.
________________________________ From: [email protected] santana [mailto:[email protected]] Sent: Friday, March 11, 2011 3:43 PM To: [email protected] Cc: Pargeter, Christie :CO IS Subject: Re: Issue with a report I am curious to know when you refresh the report in crystal reports are you getting any errors ? I am noticing that your qualification does not use underscores but the crystal report field is using underscores.. How do you have our odbc set up? to use underscores or not to use underscores? Kimberly On 3/11/2011 9:58 AM, Pargeter, Christie :CO IS wrote: ** 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"_ _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"
