Hi,

Please let me know from your experience what is better : to create Crystal Reports based on Baan Tables or on views on these tables. We run Baan 5c with SQL Server; Crystal 9.0. I need to report on table tdsls451 (sales order lines history) and I'm afraid of a bad performance in Crystal for such a big table.

Is it possible to create the view on tdsls451 directly in Crystal (maybe using Crystal Query as Database) or do I have to create the view directly on SQL Server ?

Thanks a lot and regards.

On occations we use direct access to our native database (Oracle) for quicker response in reports against big tables.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

How can we use direct access to our native database ??
Baan doesnt maintain any referential checks and primary keys at DBside?
I feel this takes long time then thru baan??
what do u say??
pls give me explantation
rgds,
jack

You need to create an ODBC connection for your SQL Server DB using the provided driver. With that ODBC connection you can then connect and access tables in your database with Crystal. The database may not have primary keys, but index 1 of each table is always created as a unique index. It is just as good as a primary key. All the referencial integrity is controlled on the Baan side, but that just requires that you do a little work in contructing some of that. The table definitions contain a lot of those references that you'll need to go by. I don't have any magic formulas to address this, other than just taking the time to try and understand each relationship.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

Can u give me the answer for a post in tools development (The subject is
Execution path??)

rgds,
jack