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
> __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"
