Re: Oterro and Crystal Reports - kudos and a problem

[aschmidt]

Neil:

Thanks for the assistance - we reported it to  RDCC a few weeks ago and
spoke to RBTI tech support.

Their feeling was that it was a bug in Crystal Reports and not an Oterro
bug. (The folks at Crystal Reports felt it was a bug in Oterro.)

RBTI also told me that none of the current Oterro owners had ever
complained about it, so that's why I brought it up here in the listserv to
see if anyone else had run into it.

BTW, in a simple comparison test, we also used MS Access to do a query
against one of the sample R:Base databases using Oterro and encountered the
same problem.


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/15/2001 09:02                                                   
                                
                    AM                                                                 
                                
                    Please respond to                                                  
                                
                    rbase-l                                                            
                                
                                                                                       
                                
                                                                                       
                                




Tony

>
> We're already using Crystal Reports 8.5
>

Given that,  I guess you'd have to put a small front end together with VB
and control report data selection that way.

I can see what you mean - I can reproduce it here.
If you use the selection expert and select on a date you end up with some
SQL that looks like:

SELECT
    Salesinf.`empid`, Salesinf.`xtransdate`
FROM
    `Salesinf` Salesinf
WHERE
    Salesinf.`xtransdate` = {d '1996-11-23'}

Crystal does the same sort of thing against a SQL Server 7 datasource,
although SQL Server understands the syntax.
It also happens whether you use OLEDB or ODBC.

Have you officially bugged it through RDCC with a small sample report
against CONCOMP?

To give the RBTI their due, Oterro 1.1  used to put a '1' on the end of all
the correllation names in the SQL Query that Crystal generated and they
fixed that....

Neil

Neil Smith
Aspen Software
www.aspensoftware.co.uk