Hi Jet community,
I am able to successfully launch Jet Reports from within Navision (local client install) using the code in the help files provided by Jet. On my local machine I have Excel 2007 and Navision 5.0 SP1.
However when I try to run the same code on our Citrix server, the CREATE(XL,TRUE) function fails and Excel is never launched. We have Excel 2003 installed on the Citrix Server as well as Navision 5.0 SP1.
When I view Global Variables, on my local machine I can see the Excel Automation variables to be:
XL Automation 'Microsoft Excel 12.0 Object Library'.Application
Workbook Automation 'Microsoft Excel 12.0 Object Library'.Workbook
Whereas on the Citrix server they are undefined:
XL Automation Unknown Automation Server.Unknown Class
Workbook Automation Unknown Automation Server.Unknown Class
When I do a lookup on the subtype and then lookup again to view the Automation Server list, on my local machine I can see the Object Library automation servers for Excel/Word/PP/etc., whereas on the Citrix server I cannot see any of these.
Has anyone had any luck with this? Is there something extra I need to do or install on the Citrix server to be able to use the Excel automation server?
Thanks in advance for any help or advice
Bobby
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Just wanted to update and say that we figured out the issue. To summarize, the Office 2003 components we needed were not installed on the Citrix machine in question. If you have Office 2003 + CDO, or Office 2007, installed correctly, you should be able to run Jet reports from Navision using the code provided in Jet's help files.
Bobby -
Jet Reports Historic Posts Hi,
U have installed excell 2003 which means Excel 11.0
U have to install excell 2007 on your citrix server to get object Excel 12.0.
Hope to help u with this problem -
Jet Reports Historic Posts Thanks for your reply. Yes I already thought about that. I don't mind using 11.0 automation objects (even 10.0 would be fine), but they don't show up either. I don't see any automation servers for Office at all.
Also, system requirements for Nav 5.0 SP1 with Office integration are met: according to the documentation, for Office integration, I need Office 2003 with CDO installed, which I have.
Any other ideas? :)
Please sign in to leave a comment.