Problem with Export to Excel

tularam

hello Experts,

I was tryig to export inventory items via Export to Excel functionality. There is a field Picture. I coded it like

CALCFIELDS(Picture);
TempExcelBuffer.INIT;
TempExcelBuffer.VALIDATE("Row No.",RowNo);
TempExcelBuffer.VALIDATE("Column No.",7);
TempExcelBuffer."Cell Value as Text" := '';
TempExcelBuffer.Formula := '';
TempExcelBuffer.Bold := FALSE;
TempExcelBuffer.Italic := FALSE;
TempExcelBuffer.Underline := FALSE;
TempExcelBuffer.Picture := Picture ;
TempExcelBuffer.INSERT;
(There i added picture field on excel buffer)

This works fine in Classic but While printing on RTC i can not get the picture exported

Please Help me>.>>>>>>

udayrmer

Try by setting Property EnableExternalImages yes in report

tularam

I am using the database not the external image

mihail_kolev

edit

tularam

mihail_kolev wrote:

edit

What to edit???

Marije_Brummel

What are you trying to achieve? Should the pictrure showup in Excel?

Does that really work in the Classic Client? I'd expect that you have done more customisation to the excel buffer table than what shows in your post.

If this works, I assume you export the picture to a folder before you pick it up in excel. Maybe the picture now sits on the service tier when run in the RTC?

ddlarsc

As already mentioned we need a little more details on the user scenario.

Do you want the data incl. the picture to show up in Excel? Are you printing from Excel or do you expect it to print directly without showing up in Excel?

When you say that classic client works, how does it actually looks there, showing in report, excel or table?

tularam

My user wants all the inventory items (For example) in excel file with picture within one of the cell after item description.
like::
Item description Picture Quantity on Hand
..........................................................................................
B1 Bicycle 234

Exactly like this in first sheet of excel file.

Maria-S

B1 Bicycle 234

Exactly like this in first sheet of excel file.

In such case you can just create a report with printed layout and select Print > Excel on request form. System will generate excel file for you.