Report generation for 20 Tags (Hourly, Daily, Weekly, Monthly, Yearly).
Need to display the log reports in the Graphic display with the provision of Start Time and End Time selection in the graphic display itself.
Option to compare the generated report with calculations (Minimum, Maximum, Sum, Average, etc. ) and need to display in the trend format.
PG2 can unfortunately not access history data with any other control than the trend controls, or a wrapper of some kind (note: wrappers should be avoided due to overhead and risk of being obsoleted in future versions; only a few remain in current version compared to 5.1 initial version, more will vanish eventually).
Parameters for report execution can be written to general properties, and be accessed from within the report code.
No, PG2 cant do this.
You could do this by making a complete "Report" ( rather than just a report screen ) with Data Direct and Excel.
- Build the report using Data Direct and Excel.
- Schedule the report in the scheduling structure. In the Scheduling definition, you can make the report run using any property in 800xA - so you can make the report run if tag in a controller changes or if a button is pressed somewhere. Or you can just run it at the end of day / month / week / shift etc.
- You can pass any required parameters, like start time, end time, batch ID, etc to the report via the action aspect or the scheduling definition aspect. Again these are values from 800xA properties.
- Configure the report to output in PDF format and save to an Object Path in 800xA. This creates a "Completed Report" object.
- Put all of the same completed report types into a reports object for that type. ( Eg "Day Reports", "Shift Reports etc.) This object is a "Generic" object type. Usually you would create this as a child of the "Reports" object in the scheduling structure. This makes it easy to find the completed reports you actually want to view later.
- You can build a List of all the completed reports in any PG2 graphic by using a "View List" graphic element. The view list element shows all of the "completed report" objects that are children of your Reports object. You can then open a completed report in a PG2 graphic simply by clicking on the report name in the view list.
- To delete old reports add a "Report Preferences" aspect into the Reports object and configure it to remove "Only Immediate Children that are Completed Reports"
See the "System 800xA Information Management" manual for more details. Note you do not need to have an IM in your system to use Data Direct.