Skip to content

Jet Reports Web Portal Setup

Setting up the Jet Reports Web Portal

The new Jet Reports Web Portal brings collaboration and sharing to a new level. Features include version control, central permissions, sharing settings as well as the ability to use Office 365 to use your reports anywhere.

Jet Reports: Server Setup

To publish reports to the Jet Web Portal you first need to install the Services Tier and the Web Portal on a local server. To do this, run the Jet Professional install and check the additional boxes.

Installing Jet Reports Web Portal - setup selections
Figure 1 - Jet Reports Web Portal Installation

The install will configure IIS and install a Jet Services Tier database. This will be used to host the web portal and control permissions. 

The last step of configuring the Jet Web Portal is to assign a certificate in IIS to direct the traffic to the newly configured web portal.  To do this:

Open IIS Manager > Server Name > Sites > Jet Web Portal > Edit Bindings

Here you can set the SSL certificate. If you do not have a certificate, then you can create a self-signed certificate by going back to the top level of the IIS management tree and opening the feature Server Certificates. Here you will find a link to Create Self-Signed Certificate that you can then attach.

Now that everything is up and running, open the Jet Administration Console and connect to the newly created service. Here you will manage the data sources and user rights. Simply add your users and data sources and now you are all setup. 

Jet Reports: User Configuration

Each user will need to have their Excel profile reconfigured to use the Jet Services Tier service. To do this, open Excel and in the Jet Ribbon select Application Settings. Inside Application Settings, change the Settings location from Local user profile to Jet Configuration Service, update the server name and test. If all is correct then your data sources and permissions are now setup and you no longer have to setup users individually.

Jet Reports Web Portal setup - Application Settings
Figure 2 - Jet Reports Application Settings

In the Jet ribbon, the Publish button should now be available. Once you build your report, you can then publish it to the Jet Web Portal using this tool. 

After published, you can run the report by logging into the Jet Web Portal page at HTTPS://ServerName

Jet Reports Web Portal Pages
Figure 3 - Jet Reports Web Portal Page

If you have any questions about Jet Reports, please contact ArcherPoint.

For more advice on using Microsoft Dynamics NAV, please visit our resource center and subscribe to our blog.

Blog Tags: 
Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube
Get Help Now