800xA 6.0.3-2 Is it possible to automatically print display or operator trend aspect?
Hello,
I've been looking for some kind of solution on how to automatically print displays or trend aspects?
I've seen some of the suggestions on this forum, for example using Data Direct and Scheduler service, but don't know how to insert display into the excel?
Why the client want this?
Basically they would like to have the same functionality as on the old system, when you could define the node from where to print and the display using FB for AC450, REPORT?
I'm more of a AC800M and 800xA myself, so please forgive me if the above statement is not quite correct.
Thanks in advance!
Katarina
I've been looking for some kind of solution on how to automatically print displays or trend aspects?
I've seen some of the suggestions on this forum, for example using Data Direct and Scheduler service, but don't know how to insert display into the excel?
Why the client want this?
Basically they would like to have the same functionality as on the old system, when you could define the node from where to print and the display using FB for AC450, REPORT?
I'm more of a AC800M and 800xA myself, so please forgive me if the above statement is not quite correct.
Thanks in advance!
Katarina
Asked 7 months ago
Voted best answer
2
The PC element Report is not supported in combination with 800xA.
There is no standard solution for the same function in combination with 800xA.
Best Regards Jan-Erik
Answered 7 months ago
Answers
2
Just an idea, try to add Aspect View invoker and Verb Invoker into any graphic, which is permanently displayed as a part of Operator workplace top bar.
Answered 7 months ago
2
I recommend using Scheduler + Excel & DD.
You need to figure out how to use the ABBGetOPCHDA() macro on a hidden Excel sheet, then insert diagram on visible sheet and adjust the axis and format the trend(s).
Then use a timer/cyclic interval or OPC DA to trigger the Scheduler to print your report.
You need to figure out how to use the ABBGetOPCHDA() macro on a hidden Excel sheet, then insert diagram on visible sheet and adjust the axis and format the trend(s).
Then use a timer/cyclic interval or OPC DA to trigger the Scheduler to print your report.
2
Given you are wishing to Automatically print a Trend, then this should be relatively easy. As suggested before: using Datadirect to get the data needed (ie same data as is shown in the trend), directly from the same logs, you can then create an extra tab in Excel and recreate the trend using standard Excel Charting tools. Then create a VBA macro that prints just the chart (Google this part if you're not familiar). the "Chart" will look mostly the same as the trend (info and traces) and should satisfy the customer. Plus you can add more info than a pure trend print would be able to achieve. I have samples if you are interested.
Add new comment