Hi Christie, I don't understand your question. I did delete the subfile and re-write it from scratch. It works fine in the User tool.
Dwayne ---- Original message ---- >Date: Tue, 6 Nov 2007 10:36:44 -0800 >From: "Pargeter, Christie" <[EMAIL PROTECTED]> >Subject: Re: Crystal report error on Mid-Tier >To: arslist@ARSLIST.ORG > >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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"