Skip to main content

Setup Jet Reports Add-in in Excel for Business Central

Introduction:

While going through the Setup of Business Central with Jet Reports as per the article from Jet Global, I noticed that for some reason I wasn't finding the same options as mentioned in the article.
Hence, I decided to try somethings on my own, and here are my findings.

In this blog, I would like to cover the JetReport Setup with Business Central Sandbox or Production.

Pre-requisites:

  • Microsoft Excel
  • Microsoft Dynamics 365 Business Central
  • Jet Report Extension Setup in Business Central
  • Jet Report Add-In installed

References:
https://support.jetglobal.com/hc/en-us/articles/360010307533-Create-A-Business-Central-Public-Cloud-Web-Services-Data-Source

Demonstration:

As you know that the setup wasn't exactly as mentioned in the article.

1. Data Source Type:
Goto App Settings > Data Source Type > Select WebServices
DataSourceType as Web Services

2. Authentication 
For Authentication, select the NavUserPassword.
Use the Username and Web Service Key from Users.
Username and Web Service Key

Authentication Type  - NavUserPassword, Username, and Password


3. WebService:
To find the details of Web Services, head over to Web Services in Business Central and search for Jet Report

Business Central - Web Services

With some minor bifurcation of the URL, I could successfully establish the connection.
Server: api.businesscentral.dynamics.com
Web Service Port: 443
Instance: /v2.0/<TENANTID>/<EnvironmentName>
User SSL Encryption: true

Jet Reports Excel Add-In - Web Services

Now, click on Test Connection and then check the Company Drop Down. If you get a list of companies, then your connection is successful.
Companies Selection

Finally, the icon for Data Source should change to a Company and you should be able to select the company.
Select Data Source in Excel Add-In

Conclusion:

I have written this blog, as documentation to setup Jet Reports. Also, it took me something figuring out so to avoid wasting time on such a small setup.

Hope this helps!😁




Labels:

Comments

Post a Comment

Let me know your comments below. I'll try my best to answer your comment

Popular posts from this blog

Something went wrong. An Error occurred - Error Resolution

Introduction: With the installation of NAV 2018 or BC On-premise, I have observed that when creating New Server Instance and New WebServer Instance, you will get the error 'Something went wrong. An Error occurred '. I referred to the community questions below but didn't find my resolution. Hence, I decided to write this blog. Pre-requisites: Microsoft Dynamics Business Central - On-Premise / NAV 2018 Understanding of Business Central Authentication  Books & References: https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/261301/nav-2018-web-client-an-error-has-occurred https://community.dynamics.com/business/f/dynamics-365-business-central-forum/421987/error-something-went-wrong-an-error-has-occurred-azure-ad-tenant Demonstration: 1. Creation of NAVServerInstance: In order to create NAVServerInstance, you can either add the Server Instance through Business Central Administration or Powershell command. Add Instance - Business Central Administration Add Insta...
Post a Comment
Read more

How to resolve 'Edit in Excel' issues

  Introduction: As you know that D365 BC offers Edit in Excel functionality. But manipulating or customizing such a  standard functionality is difficult as there is not much control available. Hence, solving issues is also a difficult task. I will be resolving the issue for this specific issue, however, the debugging steps are similar. Pre- requisites : ODATA V4 Connectivity tool for Webservices Microsoft Dynamics 365 Business Central Books & References: https://community.dynamics.com/business/f/dynamics-365-business-central-forum/448226/issue-with-excel-add-in/ Demonstration: The way Edit in Excel works is that for a given page a Webservice is created adding PageID and Page Name. Hence, there are some Webservice connectivity checks in place to validate. 1. Edit in Excel Custom Action on the page: If you are adding Edit in Excel Action on the page, please ensure that you are providing appropriate PageName and Filter criteria as Webservice is using these parameters Refer Ed...
Post a Comment
Read more

Installing LS Central - POS on local machine

Introduction: In this blog, I'm attempting to capture the LS Central - POS installation process on Local Machine. This blog has nothing to do LS Central - Server Setup for POS. LS Retail / LS Central - On Premise POS Pre- requisites : LS Central Installed on Server SSL Setup on LS Server (https://www.olisterr.tech/2020/03/how-to-setup-navuserpassword-with-ssl.html) LS - POS Installer Business Central - On Premise Installer Demonstration: Once your LS Retail / LS Central POS is setup on the main server. Just prior to Go-Live, you will actually have to install this POS on multiple systems and connect these POS to the main server with LS Retail / LS Central. 0.Preparation: Prior to actually installing Business Central On-Premise Windows Client, you need to make sure that you're able to ping the target with the correct Port number. For this I made use of PS-Ping tool.  PSPing - IP Address: Port If you're unable to PS-Ping the correct IP with Port number, simply check the Advan...
Post a Comment
Read more