Item Picture in Report for other Data Item

Dynamics 365 Business Central/NAV Technical Forum
1

Hi,

When i am running report in RTC, with Table 50015, i get the item from Item table and then try to show the picture

but in the reports all records are showing the same picture. Why this is happening. Here is the code

On aftergetrecord trigger of DataItem 50015

ItemRec.GET(“Item No.”) THEN
ItemRec.CALCFIELDS(Picture);

and on the sections in a picture box, sourceexpr is ItemRec.Picture.

Could some help me on this.

Thanks

John

2

table 50015 is a custom table, so without further details it’s hard to say

3

Are you storing picture in Table 50015 and relating with Item Master ???

4

Are you storing picture in Table 50015 and relating with Item Master ???

5

Hi,

Table 50015 is having Fields “Item No” code 20 & other fields. After some processing
this table saves some records.

Then in report I have taken 50015 as Data Item & then onaftergetrecord code is written
to fetch record from item master.

IF ItemRec.GET(“Item No.”) THEN
ItemRec.CALCFIELDS(Picture);

After the above code, description & description 2 is displayed correctly it means it is getting
record from Item Master. But picture is displayed as same for all the records.

I tried saving this picture field in 50015 but this way also it shows the same picture for all record.

Hope i am clear .

Thanks
John

6

How you are storing picture in Table ??

Is it Path of picture or you are storing in BLOB field?

7

Does 50015 store many different item numbers?

Do all the item Numbers have pictures?

Did you verify from the item card that all the pics are actually different?

Are you saying you are also pulling the item description fromm the item table in your report & it’s showing correctly?

8

Hi,

The picture is saved in 50015 as BLOB. Also all item pictures are different.

Thanks

John