Skip to main content

Load Pictures

The NL("Picture") function is supported for on-premises installations of Dynamics 365 Business Central and Dynamics NAV 2013 and higher (for which the Jet Reports NAV Business Objects have been installed, but not the NAV apps for Jet Reports or Jet Reports for Financials. )

Overview

The Jet NL("Picture") function loads an image from a BLOB field in Dynamics NAV or from a file.

Examples of the NL(Picture) function

Retrieving an Image from a Dynamics NAV BLOB Field

To use a picture that is stored as a BLOB in Dynamics NAV, enter the Table , Field , and Filter parameters that will select the correct BLOB.  You can enter "Height=" and "Width=" in the filter fields with numbers in the corresponding filters to set the height and width of the picture.  If you do not enter sizing specifications, Excel will choose a default size for the picture.

=NL("Picture","Item","Picture","No.","10000")

Retrieving an Image from a File

To load an image (.bmp, .jpg, .jpeg, .png) from a file, use an NL function with "Picture" in the What parameter, leave the Table parameter blank, and put the file name in the Field parameter.

=NL("Picture",,"C:\estdbpicture.bmp","Height=","25","Width=","30")
Note:  Loading images from a file is not supported by Jet Hub.

Was this article helpful?

We're sorry to hear that.