show image file from "Company Information"."Picture"

Business Central/NAV User Forum
1

hi all

how to show image file from “Company Information”.“Picture” in report?

i already upload to my database

but after using picture box and the source exp i fill with “Company Information”."Picture"

it still doesn’t show

2

Are you using the classic or the new VS reports?

Remember that you must use CALCFIELDS first.

3

i’m using the classic report

calcfields?

where should i execute that?

4

Before the picture is to be shown.

You should check how it is done in the standard invoice report.

5

Picture field in Company Information table is a flow field and to display value of flow field you need to use CALCFIELDS.

Have you done any coding for getting record in Company Information table? If yes, then write following

CompanyInformation.CALCFIELDS(Picture);

where CompanyInformation is the record name (it can be some other name also, check your own coding)

PS: Erik managed to post while I was writing

6

yes… it works !!

thanks you two :slight_smile:

7

but can we stretch the picture?

8

Hi,

If you stretch the picture it wont look good.If you have any web designer in your concern, tell them to modify to the exact size and then import the picture into the DB and then use it in the reports.