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"