Category: Jet Reports

If you’re using Jet Hub with Jet Reports, then when you run a report, the report run is stored in the Jet Services database;through time, this report run history can grow quite large if you either have large reports or are generating lots of reports; combine these together and the history can grow to potentially massive sizes.

Jet Hub does not, unfortunately, include an automated clear-down routine for the report run history, but, fortunately, the history is only stored in a single table.

The below stored procedure can be created against the Jet Services database and scheduled to run with SQL Server Agent; the highlighted parameter at the top can be changed to alter the number of months for which history should be kept:

IF OBJECT_ID (N'usp_AZRCRV_DeleteJetReportsReportRuns', N'P') IS NOT NULL
    DROP PROCEDURE usp_AZRCRV_DeleteJetReportsReportRuns
GO

CREATE PROCEDURE dbo.usp_AZRCRV_DeleteJetReportsReportRuns
	@iAge INTEGER = 12
AS
/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DELETE FROM
	ReportRuns
WHERE
	Runtime < DATEADD(month, -@iAge, GETDATE())

GO

As always, test the script before using against a live system and ensure you have a good backup before

I have a new book available now called Jet Reports with Microsoft Dynamics GP; this book is aimed at end-users or consultants looking to use Jet Reports with Microsoft Dynamics GP for financial and/or operational reporting.

The book covers the basics of installing and configuring Jet Reports as well as how to design and build reports using the Excel Add-in, before moving on to step-by-step guides on creating six different types of report and closing with a look at the report building tools and Jet Hub.

The book is available as an eBook direct from my azurecurve Publishing site or from Amazon (for $5 more):

• US
  • Paperback
  • Kindle
• UK
  • Paperback
  • Kindle

If you buy the ebook from me directly, the coupon code JetWithGPLaunch will get you 20% off the price of this book (offer available until the end of July 2020).

This post is part of the series on Upgrading to Jet 2019.

Earlier in this series, I did an upgrade of Jet Analytics; in this post, I am going to upgrade Jet Reports (formerly known as Jet Professional, and before that Jet Essentials).

To upgrade Jet Reports, download Jet Reports 2019:

Continue reading “Upgrading to Jet 2019: Upgrade Jet Reports”

This post is part of the series on Upgrading to Jet 2019.

As with Jet Analytics, there have been a number of improvements to Jet Reports:

• Improved Performance with XLL Multi-threaded Add-in – The Jet Excel add-in is now based on the Excel’s XLL format. This provides several benefits – including a performance boost, with some reports running up to 5 times faster.
• Business Central Data Source Connection – Dynamics 365 Business Central users can connect Jet Reports directly to their Business Central data base. Each user can use their Office 365 credentials to make their connection.
• Simulate Jet Reports Financials within your Jet Reports Excel add-in – For those Business Central customers and partners needing to support both Jet Reports and Jet Reports Financials, a new simulation mode has been added to Jet Reports to allow you to use the full Excel add-in as through it were an installation of Jet Reports Financials.
• Updated Report Wizard – Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Report Wizard tool has been updated.
• Update Notification when a new version of Jet Reports is available – A new notification button has been added to the Jet ribbon to let users know when a new version of the Excel add-in is available.
• +VALUES automatically added to reports – When running a new Jet report for the first time, in addition to Auto+Hide, +Values will now be added to cell A1. This has been a popular request in our ideas portal.
• The Jet Services Database is Backed Up during Upgrade – The Jet Reports installation program now includes the option to backup the existing Jet Service Tier database prior to updating or replacing it as part of the installation process.
• The Jet Hub has received a new look and new features – The Jet Hub features a new look (along with a new name) and the new App Switcher allows you to quickly navigate between the applications in the Jet Hub.
• Updates Emails when Adding Users to the Jet Hub – When adding new users in the Jet Hub, you can now provide an email address for each user. There is also an option to edit the email address for existing users. This information is used for sending invites to log into the Jet Hub and for notifications in the Jet Budgets application
• Assign Data Source Permissions to User and Groups within the Jet Hub – After defining data sources within the Jet Administration Console, you can now give users and groups permissions to those data sources from the Admin section of the Jet Hub
• Support for Excel’s WORKDAY.INTL function – Excel’s WORKDAY.INTL function is now supported in the Jet reports that you run within the Jet Hub.

The upgrade of Jet Reports is much simpler than the upgrade of Jet Analytics and I will cover it in the next post.

This post is part of a series of posts on implementing Jet Reports and is part of the Jet Professional sub-series. I’m a little late in posting this one, as I forgot to include it with the original series when I posted it.

Jet Professional provides a number of database views which can be used to simplify reporting, rather than using the Microsoft Dynamics GP tables (the structure of which can be confusing to many users of Dynamics GP.

However, the views are not deployed automatically, but need to be deployed after the first client has been installed. To deploy the views, log into Microsoft Dynamics GP and then start the Jet GP Updater which is in the Jet Reports installation folder:

Continue reading “Implementing Jet Professional: Deploying Jet Views”