• 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…

    Read more

  • 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:…

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more