error generating Reports in 800xa
Hi.
I am doing reports with 800 xa
i have excel and data direct
i create a excel template, where in a row i put a date (date format)
i need to create reports every day , minute per minute from 8 columns and the historic data come from specific date and time
reports works well, every day and the same hour create a new excel file in a specific folder
the problem is data on the file is not the same in comparison with historic trend
by example, if you open trend and search tag1 at 11:30 from july 1 2017, your value is 30
but excel report apear 0.
if you use f9 the update send the correct data, but only in this mode
i have used the files:
Mr Engineer a basic walk through on 800xa report configuration
and
Functional Daily Report in Excel with provided template
in excel options i used automatic update, and the option is (interpolate data) because the raw data send wrong values
VERSION IS 5.1
could you help me to solve this problem
best regards
Answers
Repeat Question:
by Stefan Stromqvist
I believe the IM Data Access and Reports User's Guide tells you to put the sheet in MANUAL mode before saving & using it as a report template.
by JORGEP110 Rank: 581 on 7/21/2017 10:34:33 AM | Like (0) | Report
i stefan
if i select manual, not made any update
best regards
by JORGEP110 Rank: 581 on 7/21/2017 10:36:03 AM | Like (0) | Report
all columns appear "name"
by Stefan Stromqvist
NAME may indicate that you have not configured DataDirect plugin for the service account. Each account need to have the plugin configured.
by JORGEP110 Rank: 581 on 7/21/2017 11:30:06 AM | Like (0) | Report
hi stefan but if pluggin is off anyone report could be created,
in raw data is not the same value than historic, you know the reason?
by Stefan Stromqvist
Not on top of my head. Out of office for another week. Please try regional ABB support if urgent.
Add new comment