My company is looking at generating reports out of Navision 3.70 and have had a quote to implement Jet Reports.
I am coming in a bit green to Navision but have had experience with other reporting packages to Accountants and am questioning the reason behind having to purchase an item to get access to the underlying tables to write reports.
I would have thought that if our database is in SQL then I should be able to access the tables via a standard ODBC connection once I have had the appropriate SQL Rights allocated on the database. I could then use what ever reporting tool that I would like. Excel, Access, Crystal or any other.
Or are there other advantages to Jet reports? Does it give you simplified views of the tables so you don’t have to hunt arround trying to link weird tables to get basic reports.
Thanks in Advance