Are these Crystal report being run from the User Tool? Somehow YES ODBC
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: 11 December 2006 14:26 To: [email protected] Subject: Re: Crystal and AR User coming up with different search results ** Are these Crystal report being run from the User Tool? If not, what database connection is being used: ODBC, Direct SQL, Stored Procedure's, etc...? On 12/11/06, Dave Barber <[EMAIL PROTECTED]> wrote: ** Interesting one. I'm putting together some reports against the helpdesk form (v5) in Crystal, and thought I'd sanity check the results with the user tool. For a given customer, in a given month, the two are giving different results. ie. customer="a" and 'create date' >= "01/11/2006" and 'create date' < "01/12/2006" Crystal gives more records, and it turns out that the user tool is omitting one record. That entry on the helpdesk form was created on the 30 November, but the user tool isn't including it. Any suggestions? It seems very, very strange. Regards Dave __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
-- *****DISCLAIMER***** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *****END OF DISCLAIMER***** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

