Should have said - nope, the reports are being run from Crystal itself via an ODBC connection. I may try it via the ARDBC instead, see if that gives different results.
Either way though, the user tool isn't correctly representing the underlying data. Disturbing. Regards Dave On 11/12/06, Frank Caruso <[EMAIL PROTECTED]> wrote:
** 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"
