Have you tried to re-select your sub-query's quals?
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Dwayne Martin
Sent: Tuesday, November 06, 2007 10:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal report error on Mid-Tier
No, the only qualification is:
'PIQ ID' = $PIQ ID$
("PIQ ID" is field 1.)
Dwayne
---- Original message ----
>Date: Tue, 6 Nov 2007 10:11:18 -0800
>From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>Subject: Re: Crystal report error on Mid-Tier
>To: arslist@ARSLIST.ORG
>
> **
> Does your active link contain a Qualification with
> datetime references?
>
> ----- Original Message ----
> From: Dwayne Martin <[EMAIL PROTECTED]>
> To: arslist@ARSLIST.ORG
> Sent: Monday, November 5, 2007 1:40:23 PM
> Subject: Crystal report error on Mid-Tier
>
> Hello everyone,
>
> We have a Crystal Report stored in Report form,
> launched by an active link.
>
> It displays find in the User tool, but on Mid-Tier
> we get:
>
> --
> Error encountered by Crystal PageServer
>
> The error message returned is:
> Error in formula . '{IT_Resource.Associated
> PIQ/Request} = {?Pm-IT_PIQ.PIQ_ID}' This field name
> is not known.. File ITPIQ3.rpt. [On Cache/Page
> Server: REMEDY.pageserver]
> --
>
> I rebuilt the sub-report from scratch, but still get
> the same error.
>
> Other Crystal Reports display OK on Mid-Tier.
>
> Any ideas?
>
> (Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.2
> db)
>
> Dwayne Martin
> James Madison University
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where
> the Answers Are"
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> __20060125_______________________This posting was
> submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
