records from different databases?

amb
amb Member Posts: 14
edited 2005-05-24 in NAV/Navision Classic Client
Hi,

is it possible to compare records from different databases in one report?

We work with one server and four local databases, which are connected like an email-solution.

I want to write a report to compare server-records with records in the local databases like that:

if server.Artikel.Artikelgruppe = local1.Artikel.Artikelgruppe then...

thx for reply.
amb

Comments

  • GoMaD
    GoMaD Member Posts: 313
    nope, not directly.

    maybe via C/FRONT
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • kine
    kine Member Posts: 12,562
    C/Front or C/ODBC or MS SQL ODBC or ADO (if you are using MS SQL server).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    Using SQL Server you could also create SQL views in the Navision database that view into other databases. Then in navision you can create linked tables.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • amb
    amb Member Posts: 14
    thanks for reply.

    Now I work with Odbc and compare the records in one excel-application, but the performance is very bad.

    A navision-report should be faster then my VBA-script.

    thx,
    amb

Categories