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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
