Message for C/AL programmers

ilianadlb
ilianadlb Member Posts: 40
edited 2008-12-11 in NAV/Navision Classic Client
I get the follow error when I try to run a report to export in excel:

/******
Could not create an instance of the OLE control or Automation server by
GUID={00020813-0000-0000-C000-000000000046}
1.5:{00024500-0000-0000-C000-000000000046}:Unknown Automation Server. Unknown class. Check that the OLE control or Automation server is correctly installed and registered.
//*****

Anybody can help me

Navision is runing in a Citrix server without Excel installed, the client has Excel, but I can't to install Excel in the server; Exists one way to run a Excel report in the client?, I can't to use a Dataport because I need to make the user design and show some calculated amounts.

thanx

Comments

  • garak
    garak Member Posts: 3,263
    edited 2008-12-10
    sorry, if only on the client is Excel and not under citrix and NAV is under citrix you can't use the Excel Export (with automations).
    But you can create text files and open this textfiles with excel
    Do you make it right, it works too!
  • couberpu
    couberpu Member Posts: 317
    ilianadlb wrote:
    I get the follow error when I try to run a report to export in excel:

    /******
    Could not create an instance of the OLE control or Automation server by
    GUID={00020813-0000-0000-C000-000000000046}
    1.5:{00024500-0000-0000-C000-000000000046}:Unknown Automation Server. Unknown class. Check that the OLE control or Automation server is correctly installed and registered.
    //*****

    Anybody can help me

    Navision is runing in a Citrix server without Excel installed, the client has Excel, but I can't to install Excel in the server; Exists one way to run a Excel report in the client?, I can't to use a Dataport because I need to make the user design and show some calculated amounts.

    thanx

    Still trying to create excel file?
    Why not CSV file and it is ascii based file that excel can open it and format it!
    Or you need to install excel on your Citrix server!
  • ilianadlb
    ilianadlb Member Posts: 40
    How can I create a CVS file?, Can I create a similar process like a Excel Automation?, or why can I do this?
  • DaveT
    DaveT Member Posts: 1,039
    Hi,

    You can use a dataport or using the commands: file.open, file.write, file.close (have a look in the help).
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • DenSter
    DenSter Member Posts: 8,307
    Why don't you install Excel on your Citrix box?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • mootsoo
    mootsoo Member Posts: 70
    Hey all! I hope all of your work going fine...
    ...I have here one problem, question.
    I'm doing one task is a related with XML port. I want to save my XML file in folder what i wanted. But i don't know how to do dialog box.

    regards
    bye my work, bye navision
  • garak
    garak Member Posts: 3,263
    This is a little bit off topic.
    Search the forum for XMLPORT and EXPORT
    Do you make it right, it works too!
  • David_Singleton
    David_Singleton Member Posts: 5,479
    ilianadlb wrote:
    I get the follow error when I try to run a report to export in excel:
    hmmm then this?
    ilianadlb wrote:
    Navision is runing in a Citrix server without Excel installed

    ](*,)

    I just don't know how to respond to that.
    David Singleton
  • DaveT
    DaveT Member Posts: 1,039
    David Singleton wrote:
    I just don't know how to respond to that.

    Try Ho! Ho! Ho! - It's the right time of year :mrgreen:
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • mootsoo
    mootsoo Member Posts: 70
    garak wrote:
    This is a little bit off topic.
    Search the forum for XMLPORT and EXPORT
    Unfortunately i couldn't find anything, in forum, in book..
    bye my work, bye navision

Categories