Problem with Export to Excel

tularamtularam Member Posts: 97
edited 2014-06-03 in NAV Three Tier
hello Experts,

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

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 ;
(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>.>>>>>>


  • Options
    udayrmerudayrmer Member Posts: 171
    Try by setting Property EnableExternalImages yes in report
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • Options
    tularamtularam Member Posts: 97
    I am using the database not the external image
  • Options
    mihail_kolevmihail_kolev Member Posts: 379
    -Mihail- [MCTS]
  • Options
    tularamtularam Member Posts: 97

    What to edit???
  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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?
  • Options
    ddlarscddlarsc Member, Microsoft Employee Posts: 19
    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?
    “This posting is provided "AS IS" with no warranties, and confers no rights.”

    Lars-Bo Christensen
    Software Developer @ Microsoft
  • Options
    tularamtularam Member Posts: 97
    My user wants all the inventory items (For example) in excel file with picture within one of the cell after item description.
    Item description Picture Quantity on Hand
    B1 Bicycle :D 234

    Exactly like this in first sheet of excel file.
  • Options
    Maria-SMaria-S Member Posts: 90
    B1 Bicycle :D 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.
Sign In or Register to comment.