Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Loading Pictures


Beginner

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 in the Jet Web Portal.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments