Microsoft Dynamics NAV (Archived)

Printing inventory images

(0) Share

Report

Posted on by spyroot

1,647

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

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

Rajasekhar@MS 5,569 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.

Was this reply helpful? Yes No
Verified answer

Community Member 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"

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 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

Was this reply helpful? Yes No
spyroot 1,647 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.

Was this reply helpful? Yes No