Hi, Keith: On various forums, it mentions that the error you encountered is a problem with the Crystal Report formula. From what I read, it appears that errorKind may be a data type mismatch in a formula.
There was one example where an individual was using an integer in place of a Boolean value in his formula. Maybe that is one place you can start. Michelle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith Sent: Wednesday, February 10, 2016 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Selecting more than 10 records in MT report error Well, the report runs fine with 11+ records when called through the User Tool, so I am thinking it's a mid-tier related issue now. Perhaps hitting a memory/cache limit? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, February 10, 2016 11:54 AM To: arslist@ARSLIST.ORG Subject: Re: Selecting more than 10 records in MT report error Hi, My guess would be that it is a specific record that is the problem, rather than the number of records. Can you check that out? Best Regards - Misi, RRR AB, http://rrr.se > Okay, here's something I want to see if anyone else has come across. > When a user selects 10 records in Mid-Tier, clicks the 'report' button > and selects a predefined Crystal Report, the report displays all ten records > without issue. > > When they select 11+, the report, displays with the following error: > > This field name is not known. Details: errorKind Error in File > BillingSiteProfileINSTALLATION111213v2008 > {80500510-C253-4CCB-8850-13FF6F5878C3}.rpt: Error in formula Record_Selection: > '({CHG_Change.Change_ID_}="C020715")or({CHG_Change.Change_ID_}="C043567")or({CHG_Change.Change_ID_}="C049824")or({CHG_Change.Change_ID_}="C054514")or({CHG_Change.Change_ID_}="C054515")or({CHG_Change.Change_ID_}="C054516")or({CHG_Change.Change_ID_}="C058635")or({CHG_Change.Change_ID_}="C058636")or({CHG_Change.Change_ID_}="C065950")or({CHG_Change.Change_ID_}="C068192")or({CHG_Change.Change_ID_}="C069264")' > This field name is not known. Details: errorKind > > Any ideas why this happens? I have refreshed the report, verified the DB, etc. > Specs: 8.1.2 MT & ARS on CentOS, Oracle11 DB, Tomcat 7. > > Keith Sinclair > Remedy Development > ShopperTrak Chicago, USA > O 312.676.8289 > ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | > shoppertrak.com Retail Profitability, Improved. > > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"