Re: Oterro and Crystal Reports - kudos and a problem

[aschmidt]

Neil:

We're already using Crystal Reports 8.5

Tony

Anthony Schmidt
President
The Computery Ltd.
One East Main Street
Bay Shore, NY  11706

Voice 631-665-8100
Fax 631-969-5988



                                                                                       
                                
                    "Neil Smith"                                                       
                                
                    <neils@aspensoftw        To:     <[EMAIL PROTECTED]>           
                                
                    are.co.uk>               cc:                                       
                                
                    Sent by:                 Subject:     Re: Oterro and Crystal 
Reports - kudos and a problem         
                    owner-rbase-l@son                                                  
                                
                    etmail.com                                                         
                                
                                                                                       
                                
                                                                                       
                                
                    05/14/2001 02:49                                                   
                                
                    PM                                                                 
                                
                    Please respond to                                                  
                                
                    rbase-l                                                            
                                
                                                                                       
                                
                                                                                       
                                




Tony

> But there is one type of query that doesn't allow us to use  "Use Server
or
> indexes" - a query based on a date data type.
>
> I've reported this to RBTI, but have been told it's because the Crystal
> Reports query engine inserts "garbage" into the query whenever it's based
> on a date. The tech support folks at Crystal Reports deny that and state
> that they pass the same query that is passed for any other data type
except
> to designate it "d" as a date data type.

What version of Crystal are you using?

We are using VB/Oterro 2000 & Crystal 8.5 - our code always sets the SQL
Query expression of the report so we haven't run into this problem.

The SQL produced by Crystal 8.x for its queries does seem to be better that
earlier versions.  But I you're already using 8.5........

Best regards

Neil

Neil Smith
Aspen Software
www.aspensoftware.co.uk