Hi all,
While reading today in Microsoft Website about new features of Microsoft and guess what i found.
Power Pivot an replacement for Jet Reports.
It connects to SQL Database in the same way but i don't know about the License but it don't have those issues which we have for JET Report License Issue.
Power Pivot can be downloaded From here.
Below are the some images of Power Pivot.
Let's see is it a replacement for JET Reports.
Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/
While reading today in Microsoft Website about new features of Microsoft and guess what i found.
Power Pivot an replacement for Jet Reports.
It connects to SQL Database in the same way but i don't know about the License but it don't have those issues which we have for JET Report License Issue.
Power Pivot can be downloaded From here.
Below are the some images of Power Pivot.
Let's see is it a replacement for JET Reports.
Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/
I think you got your fact wrong,
ReplyDeletePower Pivot is not a replacement for Jet Reports, can you post the original article where you think you've ready this ?
Jet Express is shipped for FREE for all Dynamics NAV 2009 and Dynamics NAV 2013 customers.
http://jetexpress.jetreports.com/en/index.php
Power Pivot is a tool geared towards developers not really en users.
Now tell us how do you handle CaptionML, FlowFields, FlowFilters, Advanced Dimensions,NAV Security/Roles, Calling a Codeunit from Power Pivot and other niceties from Power Pivot ?
Power Pivot is an amazing tool, but in terms of productivy and ease of use for the end user, it does not come close to Jet Reports.
That's why Microsoft do ship Jet Express for free because they do need the best end user reporting tool on NAV, and that's what Jet Reports is all about.
Hi,
DeleteThe stated article were just my views, not any facts were shared.
Jet is shipped free with Dynamics NAV but customer need to buy Viewer and Designer License for Report execution.
From NAV 2013 Execution of JET Report is show as it pulls data from Web service which again takes longer time to execute than Power pivot which extract data directly from SQL.
Regards,
Saurav Dhyani
I'm a little suprised that the original poster didn't repy to your reply.
ReplyDeleteActually you have both of thoss facts wrong too. Jet Express supports unlimited viewers and desigers with no additional licensing.
While you are correct that Jet Express pulls information from a web service, you are incorrect about PowerPivot pulling the information directly from SQL. It technically can, but this will never work in any real implentation because it bypasses the security model and end users do not have dbo access to the database.
The only way that PowerPivot should be used with NAV is also over a web service. Prior to NAV 2013 web services were available over SOAP protocols, but with NAV 2013 there is now an OData protocol available as well which will work with PowerPivot.
So, yes, PowerPivot works fine with NAV 2013 and is a good option. Jet Express is provided by the Microsoft Dynamics team as an even better option. They invested in this technology so a reasonable person would assume that there was a reason for this.
Probably best for you to do a little more fact checking.