how to print report using changing the time
regarding of the report printing in 800xa 5.0
I just created the expression for triggering report printing in HTML format by changing the time in the input field.
but my requirement is
at x time when the change in time is occurred in one row the value to be updated and
at the x1 time when the change in time occurred another row the new value should update and the same for 24 hrs or changing shift
after 24 hrs or change in shift, the new report should report in the next excel or html
Voted best answer
If the daily or shift report shall print some accumulated values, those values need to be temporarily stored somewhere and later recalled by the report.
Either you configure synchronous logs, a primary with a short Min Time (e.g. 5s) + 2xMax Time (e.g. 10s) and a secondary with a calculation aggregate (e.g. TimeAverage, Delta, etc) and a Min Time of your desired data interval, e.g. 1 hour. The secondary log does not need a Max Time. The length of the logs only need to cover the reporting period, e.g. a day.
Or you configure asynchronous lab logs in Basic History (e.g. 100 samples long, or what is needed to cover a shift/day) and use a Calculation aspect to fill those lab logs with data when there is data available to store. The Calculation can be scheduled on a timer, or made to trigger on a process value. Hence the lab log will automatically collect production data, when something has been produced. No production = no new data written to the lab log.
On top of the logs (either synchronous or asynchronous) you configure a report that triggers on day or shift change, read the logged data out of the logs, convert/transform and print it.
I have written here on AKS how to create lab logs using Basic History and Calculations. Here is an example: