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] <mailto:[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"

Reply via email to