Has anyone done reporting across Baan companies using Crystal?

We are a Baan IVc3 running Oracle on Unix.

Done that. You to use an alias and change the location settings for that specific table in order to do that

Rgrds,

I believe that you want to use the "_compnr" field that is on each Baan table that Crystal's Baan driver displays. By using it in the WHERE clause to specify a different company or set of companies, you can then report data from several companies off the same table.

Gilbert Guymer
Database Adminstrator
Lufkin Industries, Inc.

Just give all the comapnies you want in the select expert of ._compnr for that table and you can see data across companies.