Create reports with data from multiple databases/companies?

mxlim

Hi All,

Is it possible to create a report which consolidates data from multiple databases or companies? The databases are stored in a SQL server running Navison 4.0 SP1.Is it possible somehow to merge selected data from multiple databases into one database (ie the main db) or is it better to just import the data using dataports?

I've also heard of a program JetReports that can "collect data from multiple tables without programming. Even consolidate data from multiple databases
with Jet Reports Universal Connector." I was wondering if we could do the same through programming.

Thanks and regards,
Nicholas

jannestig

HI there,

if you want to run then as SQL server report SSRS or do you want a navision report. I know we have similiar reports over tables that are shared through multiple companies.

kriki

Different companies is easy : use rec.CHANGECOMPANY and you can read the table in some other company.

Different DB's is more complicated:
-you can use ADO. This might help :http://dynamicsuser.net/blogs/waldo/archive/2008/01/06/using-stored-procedures-in-c-side.aspx
Or search the forum for more help on ADO
-You can also use SQL views : check this one : http://techblog.byllemos.com/?p=67

mxlim

Thanks kriki..that's exactly what I wanted..well will try it out soon.

Regards,
Nicholas