Problem with Export to Excel

tularam
tularam 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

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

Comments

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

    What to edit???
  • Marije_Brummel
    Marije_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?
    Marije Brummel | Freelance Business Central Specialist
  • ddlarsc
    ddlarsc 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
  • tularam
    tularam 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.
    like::
    Item description Picture Quantity on Hand
    ..........................................................................................
    B1 Bicycle :D 234

    Exactly like this in first sheet of excel file.
  • Maria-S
    Maria-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.

Categories