Multiple Databases

[mgreer]

I am trying to create a report in CRW8 that connects to several sql databases on the same server. Each db being a client. Then the report needs to group by client to display data. Does anyone know how to accomplish this? I would preferably like to use asp and Automation server... but am open to anything.

thank you.

 

[synapsevampire]

Consider a Stored Procedure (SP).

You can call the report however you'd like (ASP, etc.), the SP will do all of the database work.

If you can't use a SP, and the tables aren't dynamic, just set the report up in Crystal Reports by connecting to each database. One complication may be that you have multiple tables of the same structure, so joining/Unions may be tricky.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com