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

Loading Pictures


 

To load an image from a file (.bmp, .jpg, .jpeg, .png), use an NL function with "Picture" in the What parameter, leave the table blank, and put the file name in the Field parameter. To use a picture that is stored as a BLOB in Navision, 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.

The following NL function displays a picture from Navision for Item 10000.

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

The following NL function that will display a picture from a file with the height and width specified.

=NL("Picture",,"C:\estdbpicture.bmp","Height=","25","Width=","30")

 

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments