I have a report that leaves the date off of the empty rows if the equipment does not run that day.
Example: equipment didn't run on the weekend and the report left out the date for the 24th and 25th. I need the date to be on the report:
You will have to modify the query to do so. Show your query.
If the tag historian, ensure that data gets recorded even when the machine is down.
The tags are set to log "On Change". So I gather that no new records were created after the equipment was shut down on Friday evening, If I change the sample mode to Periodic, then I'm filling the dB with zeros but that would let the report generate the row with the date displayed. Is there a different method to accomplish this so I don't have to log unnecessary data?
You could use a script data source to reprocess the historian result to inject the missing rows during report generation.
1 Like
Sounds good, I will give it a try!