Microsoft Dynamics NAV (Archived)

Printing inventory images

(0) Share

Report

Posted on by spyroot

1,645

Hello my friends,

Here is my challenge of the day:

I want to generate a report to show/print all expenses with their respective pictures (receipts). The pictures already exist in same custom table.

I'm using the command CALCFIELDS(FieldName) to call the value of the blob under AFTERGETRECORD, but the report still printing the same picture on all transactions.

Any suggestions will be appreciated.

*This post is locked for comments

All responses (4)

Answers (3)

spyroot 1,645 on at

Like (0)

Report

RE: Printing inventory images

I found the error. I was selecting the field through the fx button rather than using the drop-down arrow.

Thank you so much for the help.
Verified answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Printing inventory images

May be you are not clearing the variables used in report as well as check dataset and rdlc report
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Printing inventory images

Hello Alex

in report builder ,go to image properties

make sure that set expression field equal "=Fields!Picture.Value"
Verified answer

Rajasekhar@MS 5,567 on at

Like (1)

Report

RE: Printing inventory images

Hi

Check the dataset whether in code is your custom rec changing on AftergetRecord, if yes then you need to work on your RDLC, how you have used CustomRec.Picfield else

Use CLEAR(CustomRec) on Aftergetrecord, like below.

Clear(CustomRec);

CustomRec.Get --> get your CustomRec

CustomRec.calcfields(Picturefieldname);

add customrec.Picturefieldname to dataset and check.