Nav integreration with SQL

ashluvuall

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 ](*,)

matttrax

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.

ashluvuall

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

Why are you trying to do this? Isn't the NAV report writer capable of producing this report?