Report Generation error in Compaact HMI V5.1
I am getting an error in Report generation in compact HMI V5.1. I am using MS office 2007. After creating a report template using DataDirect i scheduled it for automatic generation. It run with an error "Could not get excel PID (DirectData Not installed)" and it is creating the replice of the template but with the template values. After pressing the F9 button only i am getting the new value. Can any know what could be the problem and how to fix this.
Voted best answer
have you set the Excel (and Word) Macro Security Settings for the Service Account?
If not do so:
please log on to the Compact HMI PC as the Service User (Service account, which by default is SwServiceAccount, the default Password is the password of the Installing user SysAdmin)
Then Start Excel and set the Macro Settings in the Trust Center to "Enable all macros". If this works you can also try with Macro Settings "Disable all Macros except digitaly signed macros)
I hope this helps!