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"