Category: Knowledge Base

JavaScript Records

We have extended the JavaScript Record functionality so that most database operations can be done without writing JavaScript code.   To change or add a JavaScript Record in a report, in the Property Grid, in the Records row, click the assist edit button (…).   In the Collection Editor, you can now add or change

Continue Reading

Calculating week numbers

JavaScript does not have a built-in function to calculate the ISO week number from a day. Therefore, to get the week number, in the ForNAV Designer, you must paste the following code into the OnPreReport trigger:   Date.prototype.getWeek = function() {   var date = new Date(this.getTime());   date.setHours(0, 0, 0, 0);   // Thursday

Continue Reading

Update ForNAV on premise (BC14 and later)

Updating ForNAV in on-premise (OnPrem) situations is a five-step process: Download the latest version of ForNAV from https://www.fornav.com/download/ Install ForNAV on the Designer computers. Install ForNAV on all service tiers. Upgrade the report pack extension (optional). Upgrade the custom ForNAV reports. 1. Download You can download the latest version of ForNAV from https://www.fornav.com/download/. This download

Continue Reading

Update ForNAV from on premise to cloud

Moving your ForNAV reports from on premise (OnPrem) (C/Side or extensions) to cloud is a matter of conversion. On premise ForNAV reports use a dll to render; cloud ForNAV reports use a web service, therefore you must convert your reports. This conversion is a three-step process: Upgrade to the latest version of the ForNAV Designer

Continue Reading

New JavaScript properties and functions in ForNAV 5.4

With version 5.4, you can now do everything in JavaScript that you can do in AL, and much more. And the Field List in the Designer now makes it easier to use properties and functions on the report and dataitem object.   For example: CurrReport.<dataitemid>.Pdf.Append(<Rec.BlobField>) –  appends a PDF from a blob field to the

Continue Reading

Hide the Design option on the request page

This article applies to on-premise Microsoft Dynamics NAV/Microsoft Dynamics 365 Business Central installations running the role tailored client. The Design option is shown on the request page of ForNAV reports, if the ForNAV Designer is installed on the client machine and you are a SUPER user in Business Central. This makes it relatively easy to

Continue Reading

A transaction must be started

If you are running a ForNAV report based on version 5.3 or earlier in Business Central 16 or newer, you might run into the following error when you save your report as an Excel document: A transaction must be started before changes can be made to the database. Microsoft Excel export problems are typically caused

Continue Reading

AL Project Settings Requirements

When you add ForNAV reports to your AL project, there are a couple of things you must set up. If you are starting a new project, the Designer can create a new project folder for you. Click Extensions on the toolbar and select New Extension Project. The Designer asks you which version of Business Central

Continue Reading

Archiving in ForNAV

This Knowledge Base article is relevant for ForNAV Report Pack 5.4 and higher.   In the ForNAV Report Pack 5.4 for Microsoft Dynamics 365 Business Central Cloud and Business Central OnPrem version 16 (and higher), ForNAV now supports archiving when a report is previewed, downloaded in Word/HTML/PDF, or printed.   To use this feature, you

Continue Reading

Layout export and import

In the ForNAV Customizable Report Pack version 5.3, we’ve significantly improved the management of customized layouts. Custom report layouts All ForNAV reports have a built-in layout. This is the default layout that ForNAV has designed for you. There are two ways of customizing the built-in layout: by cloning, and by creating a customized layout. A

Continue Reading