-
[quote user="David Singleton"]I was working on a blog about this, so I'll finish it today. But in general, this is a very hot topic here since the days of NOLUG first thing to do is to take a look at the old posts: go here http://www.mbsonline.org/forum/search.asp and enter native sql there...
-
Microsoft SQL Reporting Services is a pretty interesting reporting tool but it is not a specific Navision reporting tool; it is a reporting tool for Microsoft SQL Server. All Navision reports are currently developed in the internal Navision reporting tool, so the backside of Reporting Services is that...
-
Another thing to consider is your report requirements as Colin said but not only "Excel reports". Navision native reports are rather simple and users needs to login to Navision to view the reports. SQL server offers Reporting Services, a reporting tool very different from the reporting tool...
-
Worth also asking the question "is there a person in the company that is an Excel or Access superuser, who is also great at producing reports"? If so, the SQL option can be a dream for them if they are hooking up data from several sources as well as Navision. The SQL support need not be needed...
-
Another point I would make is, although the native database is extremely efficient and the program was designed around the native database, no one can be sure how long it will survive and be supported. SQL server has higher costs involved and like my learned collegue said previously, you will need a...
-
My base idea for SQL-server is. If you already have it, you can opt to use it. If you need to buy/install it, do it only under certain circomstances. -You want an uptime of 99.99%. This is almost impossible with a Navision-DB in case of a server-crash. -You have a DB of a lot of GB's and backing...
-
I was working on a blog about this, so I'll finish it today. But in general, this is a very hot topic here since the days of NOLUG first thing to do is to take a look at the old posts: go here http://www.mbsonline.org/forum/search.asp and enter native sql there are 28 pages Basically though, if Native...
-
As and end user, I have been tempted to switch to SQL server, but haven’t been able to justify the cost. So, here is my scenario for you: If you are selling Microsoft Dynamics Nav 4.0 to a new company, they are sold on the benefits and you have priced out the granules for their complete installation...
-
Now that sounds pretty interesting, as it stands now, any time someone needs a report, they ask me and I find what they need and print it out. More automated reporting and interactive reports sound very interesting.