We're creating some new reports, and need to pull some data from
another database. Is there an efficient way to do this? The wire
traffic should actually be less as we're just getting product names to
match to IDs, but it seems that Crystal is doing a lookup for the name
in database 2, for every row returned from database 1. I would think
it would create a set of IDs, and then do a query to get the matching
names.

Thanks, Rick DeBay