General Discussions
Report Multiple Tags as a Set

Is it possible to run a report (or create a custom report) to display the current value of multiple tags all as a single row at a common timestamp that is based off of a trigger or specific tags timestamp (rather than at an hourly or other timeframe snapshot specific time)?

I frequently get requests from users to set up reports or historical data exports to allow them to track and save multiple tags all at the same timestamp. This is usually manageable with snapshot reports, but my current problem is a little different:

We periodically run an ad-hoc process in which 18 different PLC tag values are tracked and when the process is complete these values are indexed and saved. There is no set schedule for this process, and no expected time duration or time between processes to use as a starting point.
These are analog tags (average flow, max flow, Equipment ID#, duration per phase, etc.) and also string tags (start date & time, end date & time, etc.). These tags are read by VTScada and displayed on screen, and as the process is completed the PLC indexes them to record the last 10 process runs data. Admin would like to be able to report on this data.
The issue with reporting is that all historical tag updates happen at different times (by fractions of seconds) so the report will have anywhere between three and eight line items for each event. Even with using a multiwrite tag to output the data to new tags based on a trigger, there are still multiple line items in a standard report that all have the same time and raw timestamp values.
I'm unsure what to try next as it feels that the historical data will never be able to be queried this way (especially with some of the tags being strings) and that a custom coded report may be my best bet, which would be new territory for me.

Is it possible to run a report (or create a custom report) to display the current value of multiple tags all as a single row at a common timestamp that is based off of a trigger or specific tags timestamp (rather than at an hourly or other timeframe snapshot specific time)? I frequently get requests from users to set up reports or historical data exports to allow them to track and save multiple tags all at the same timestamp. This is usually manageable with snapshot reports, but my current problem is a little different: We periodically run an ad-hoc process in which 18 different PLC tag values are tracked and when the process is complete these values are indexed and saved. There is no set schedule for this process, and no expected time duration or time between processes to use as a starting point. These are analog tags (average flow, max flow, Equipment ID#, duration per phase, etc.) and also string tags (start date & time, end date & time, etc.). These tags are read by VTScada and displayed on screen, and as the process is completed the PLC indexes them to record the last 10 process runs data. Admin would like to be able to report on this data. The issue with reporting is that all historical tag updates happen at different times (by fractions of seconds) so the report will have anywhere between three and eight line items for each event. Even with using a multiwrite tag to output the data to new tags based on a trigger, there are still multiple line items in a standard report that all have the same time and raw timestamp values. I'm unsure what to try next as it feels that the historical data will never be able to be queried this way (especially with some of the tags being strings) and that a custom coded report may be my best bet, which would be new territory for me.
13
0
1
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft