Are the erroring fields in the View that the report is running against? The Mid-Tier seems to be sensitive to that whereas the WUT is more forgiving. Also, are those fields similar in name to other fields on the form? For example, do you have both "Entry ID" and "Entry_ID"? I could see crystal server getting confused about something like that.
By the way, you definitely want to have "use underscores" checked in your ODBC config. Regards, Chuck Baldi On Thu, Feb 25, 2010 at 12:21 PM, Joe D'Souza <[email protected]> wrote: > ** > Dwayne, > > Another thing I might have tried doing just for kicks, is editing the report > using Crystal designer, remove the query, recreate it, remove the field from > the results, add it back, save, and then add the report file to the Remedy > reporting application again. > > Then flush the MT cache if required again, and try the report from the web.. > > That would hopefully 'repair' any potential problem that might be with the > rpt file itself.. > > Joe > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]]on Behalf Of Martin, Robert > Sent: Thursday, February 25, 2010 12:16 PM > To: [email protected] > Subject: Re: Crystal report can't find field in Mid-Tier > > ** > > Thanks for the suggestion, Joe. That one didn’t work either, but it was > worth a try. > > Keep ‘em comin’. > > Dwayne > > > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Joe D'Souza > Sent: Thursday, February 25, 2010 9:11 AM > To: [email protected] > Subject: Re: Crystal report can't find field in Mid-Tier > > > > ** > > I doubt it has anything to do with the Mid-tier cache, but could you try > flushing it and then retry the operation? > > > > Joe > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]]on Behalf Of Martin, Robert > Sent: Thursday, February 25, 2010 8:44 AM > To: [email protected] > Subject: FW: Crystal report can't find field in Mid-Tier > > ** > > Thanks for the suggestion, Latzko. > > I went to the host machine ODBC and the only thing checked was “Use > Underscores.” I unchecked it, but it didn’t make any difference either to > the reports that work or those that don’t. > > > > Dwayne > > > > From: Latzko Joachim [mailto:[email protected]] > Sent: Thursday, February 25, 2010 8:30 AM > To: Martin, Robert - martinrd > Subject: AW: Crystal report can't find field in Mid-Tier > > > > Have you checked the ODBC data source on the machine where the Crystal > Reports server is installed? There are some options like 'use underscores' > and so on. Compare that to the setting of the ODBC Data Source on your > workstation. > > > > ________________________________ > > Von: Action Request System discussion list(ARSList) im Auftrag von Martin, > Robert > Gesendet: Do 25.02.2010 14:27 > An: [email protected] > Betreff: Crystal report can't find field in Mid-Tier > > ** > > Dear List, > > We have several forms with buttons that call active links, that open Crystal > Reports for the entry on which the button resides. They all work in the > WUT. > > But in Mid-Tier, there are two forms that give the error: > > This field name is not known. Details: errorKind Error in File > C:\WINDOWS\TEMP\{71402FB4-0BAE-468A-AA5F-9E7AAEDC95CA}.rpt: Error in formula > . '{CS_CallEntry.Entry_ID}="CS000148"' This field name is not known. > Details: errorKind. > > I checked in SQL developer, and “Entry_ID” is the correct field name in > CS_CallEntry. If it wasn’t the report would fail in the WUT as well. (The > other form gives a similar error, but with a different form and field name.) > > So why can Mid-Tier find the Entry_ID for all other forms, but not these > two? And why can the WUT find it, but not Mid-Tier? > > (ARS and Mid-Tier 7.1 p3, RH Linux server, Oracle 10.2 db) > > Dwayne Martin > > James Madison University > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
