You can automatically generate reports from SQL Server, Oracle, and Access data, based on event, continuously, or time of day with a dynamic query to filter what data is returned.
By using the product OPC Report.NET this is easy to setup.
View the following video for a detailed presentation on generating reports.
Other resources for report generation:
Data Logging to log data values to the database.
Alarm Logging to log alarms to the database.
*Note: If you want to transfer real-time values to Microsoft Excel use the product feature OPC Excel.NET.