Category: Knowledge Base

CurrControl

Setting forecolor, back color, font, and formatting dynamically on a control ForNAV supports a wide array of properties to control the look of controls. However, sometimes you might want to control the look dynamically, based on values in the data set. To do this, you use the OnPrint JavaScript trigger. The OnPrint trigger has a

Continue Reading

Error in Report Selection

You might get the following error message when printing or sending a ForNAV report: The SourceExpr for report control ‘ReportForNav_Header’ is not valid. The following error occurred: A call to System.IO.Compression.ZipArchive failed with this message: The value of Seek/OffsetFromEnd parameter is outside of the permitted range. The current value is: -18. The permitted range is:

Continue Reading

ForNAV Granule Required

To use ForNAV and work with the ForNAV Designer using extensions in Microsoft Dynamics 365 Business Central v14 and later, in an OnPrem (or private cloud) scenario, you must have the ForNAV granule (6188500 Reports ForNAV) configured in your Business Central license file. This is due to how Microsoft licensing and permissions work. A Microsoft

Continue Reading

NavHelperFunction

When converting RDLC reports to ForNAV reports, you will notice that the Showoutput value on sections and controls sometimes has a function call to the NavHelperFunction, like in the following example from the RDLC Purchase Invoice:   NavHelperFunction.IIFNOT(DynamicsNavDataSet.ShowInternalInfo==true && DynamicsNavDataSet.DimText_DimensionLoop1!=””,false,true)   The NavHelperFunction has been put in place to emulate some of the built-in RDLC

Continue Reading

Using e-mail body with a ForNAV report

This article is no longer relevant and has been replaced by this article: ForNAV email body layouts

Continue Reading

ForNAV and Docker Containers

You can use Reports ForNAV with your Docker containers. The following is a step-by-step example of how to set up a container that supports ForNAV reports. Install the BC Container Helper To help install your container, you must install the BC Container Helper PowerShell module. install-module bccontainerhelper -force get-command -Module bccontainerhelper Write-BCContainerHelperWelcomeText Create the container

Continue Reading

Import a Custom Report Layout in ForNAV Cloud

To import a custom report layout in ForNAV Cloud: In Microsoft Dynamics 365 Business Central, go to the Custom Report Layouts window. Click New. In the Edit window, enter the report ID and select Insert Word Layout. In the Report Name field, rename the custom report layout to something recognizable, for example, ForNAV BC custom

Continue Reading

Blocked by the runtime

When running a ForNAV report, you might receive the following error message: “The request was blocked by the runtime to prevent accidental use of production services.” To resolve this issue: In Business Central, on the Setup & Extensions page, in the Search field, enter fornav. Select ForNAV Core and then click Manage, Configure. On the

Continue Reading

Trusted Certificates

Trusting Your Service Tier Certificate If you want to connect your ForNAV Designer to a service tier using secure communication via HTTPS/SSL then you need to be able to trust the certificate installed on the service tier. Normally, your service tier certificate used in a production environment is a valid certificate that was issued by

Continue Reading

How to Import an Extension

Install or remove a per tenant extension in Microsoft Dynamics 365 Business Central This KB article is relevant for Microsoft Dynamics 365 Business Central Cloud production environments. For sandbox environments (cloud) and OnPrem, we recommend you use the ForNAV Designer.   To install a per tenant extension in Business Central: In Business Central, go to

Continue Reading