Is {?Pm-IT_PIQ.PIQ_ID} a formula field on the Crystal report or a field on
the Remedy form? If {?Pm-IT_PIQ.PIQ_ID} is a field on the Remedy form, maybe
the report is confusing it for a formula field because of the '?' as a
prefix to its name. Try renaming it, verify the database in Crystal reports,
add the new rpt file and run the report..I also have a doubt on the way Crystal is interpreting the '/' character in the field IT_Resource.Associated PIQ/Request. Have you checked use of underscores? I don't recall offhand if a '/' character should get converted to an '_' character as when you use underscores so make sure you have that checked.. Cheers Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin Sent: Monday, November 05, 2007 3:40 PM To: [email protected] 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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.23/1113 - Release Date: 11/6/2007 10:04 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
