Skip to main content

Replacement of JET Reports

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/
Labels:
Location: Sector 62, NOIDA, Uttar Pradesh, India

Comments

  1. AnonymousJanuary 9, 2013 at 4:23 PM

    I think you got your fact wrong,
    Power 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.

    ReplyDelete
    Replies
    1. Saurav DhyaniJanuary 9, 2013 at 5:03 PM

      Hi,

      The 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

      Delete
  2. AnonymousJanuary 18, 2013 at 9:48 PM

    I'm a little suprised that the original poster didn't repy to your reply.

    Actually 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.

    ReplyDelete

Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------
10 comments
Read Complete Article »

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searching for the error i figured out the issue was due to - Design change in NA
4 comments
Read Complete Article »

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.
Post a Comment
Read Complete Article »