Images

Business Central/NAV User Forum
1


How to Write a report that Exports all the images stored in Employee record to C: drive?



please help me
2

Hi

1.Create a report with Employee table as your data Item

2.Create a text variable and name it Destination

3.go to the OnAftergetRecord() of your data item and place the below code

Employee.CALCFIELDS(Employee .);

IF Employee.).HASVALUE THEN

Begin

Destination := ‘C:\Songs\’+Employee.Code+’Bmp’;

Employee.).EXPORT(Destination,FALSE);

End;

  1. Go to the report properties and change the ProcessingOnly property to yes

5.Create a folder at c drive and name it Songs

6.run your report

Thanks

Jerome Marshal.J

3

Wat is the meaning of picture field bro…?

4

Your requirment is export all the images from employee table na so that employee table must have field with data type blob

where ever i mentioned Employee. you select that blob field from the employee table

5

Thank you Verymuch Bro,its working.

i want more support from u .where r u from and for which company u r working?

Thanks&Regards,

Veeraprasadgupta,

Navision Trainee,

Hyderabad…

6

hey bro that is 6.1 version of navision.that employee table is from cronus company