Nav integreration with SQL

ashluvuall
ashluvuall Member Posts: 6
edited 2009-04-05 in NAV/Navision Classic Client
Hi,

I have to generate a report from nav with business logic on sql. in other word i want to pass a sql query from nav and reterive the output in nav. without using NAvison Application server. Please help me on this. :-k ](*,)

Comments

  • matttrax
    matttrax Member Posts: 2,309
    You certainly can do it, but why do you HAVE to do it? NAV handles most of the queries you would need to use. If you HAVE to do it this way just search the forum. I've seen a few posts on how to embed SQL inside NAV code. It requires use of an automation variable, though.
    Matt Traxinger - ArcherPoint
  • ashluvuall
    ashluvuall Member Posts: 6
    as you suggested to try with automation but when i looked at there are many sub types so can suggest me which one to use. and i am not able find the topics can you suggest me link.

    Regards
    Ashutosh
  • bbrown
    bbrown Member Posts: 3,268
    Why are you trying to do this? Isn't the NAV report writer capable of producing this report?
    There are no bugs - only undocumented features.

Categories