Dwayne, It was the ODBC configuration I was talking about. By the way calling "?Pm-" a formula field was a devils error. I meant the parameter field.. sorry about that..
If you already have the 'Use underscores' checked, just for the purpose of eliminating possible problems, could you hit the option to 'Verify Database' and save the report? On doing so import that report into the Remedy reporting forms and then try re-running the report. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin Sent: Tuesday, November 06, 2007 11:33 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report error on Mid-Tier Joe, "?Pm-" means that it is a prompt, and not part of the field name. It is the sub-report link that the main report feeds to the sub-report for record selection. The "/" could be a problem. You say to make sure I have "Use underscores" checked. It is checked on the server ODBC. Is there anyplace else it should be checked? I can't find anything in Mid-Tier configuration. Dwayne ---- Original message ---- >Date: Tue, 6 Nov 2007 09:58:51 -0500 >From: "Joe D'Souza" <[EMAIL PROTECTED]> >Subject: Re: Crystal report error on Mid-Tier >To: arslist@ARSLIST.ORG > > ** > 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: arslist@ARSLIST.ORG > 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"
