Create Report for mySQL and other database engines without OLE-DB Provider

In MySQL create a separate user from root. You will uses this user in the string below.

ServerIPAddress=xxx.xxx.xxx.xxx
DataBaseName=The database name of interest inside mySQL
MYSQLUserName = The MySQL username provided above
MYSQLUserNamePassword = The Password to the database for the username provided

No spaces between elements.

Database = DatatBaseName
Table = a table within the database.

Dataset should now show table elements.

Frequently Asked Questions – Reports

When I use multiple DataSets in the same report it only returns data from the first DataSet.
Use and RDL Report type.
I am using GMAIL as the sending address.
Make sure to enable SSL and also set the outgoing port number to 465.
Report queries are running very slow from the database.
Make sure the date and time span or Query String is defined to return a subset of data instead of all of the data. You can also reindex the database in SQL Server to run faster. Reorganizing and Rebuilding Indexes http://msdn.microsoft.com/en-us/library/ms189858.aspx
Create Report for mySQL and other database engines without OLE-DB Provider
In MySQL create a separate user from root. You will uses this user in the string below. ServerIPAddress=xxx.xxx.xxx.xxx DataBaseName=The database name of interest inside mySQL MYSQLUserName = The MySQL username provided above MYSQLUserNamePassword = The Password to the database for the username provided No spaces between elements. Database = DatatBaseName Table = a table within the database. Dataset should now show table elements.
Set Printer Driver to work with Automated Reports
The OAS Services by default run under the SYSTEM account. The following link is a guide for setting up the printer driver to work with the SYSTEM account. https://support.microsoft.com/es-mx/help/184291/com-objects-fail-to-print-when-called-from-asp

Reports

Overview – Reports

The OAS Report product provides the Report Designer for easily creating reports from data logged with OAS Data Log or OAS Alarm .NET. These reports are then executed from selectable execution types such as event driven from a Tag, continuous as a specified frequency, hourly, daily, weekly, or monthly.

Filter constraints can be added for filtering data to previous  hour, current hour, previous day, current day, previous week, current week, previous month, current month, or custom time frame.

You can also use an Open Automation Software Tag value with a string data type as a dynamic query string to filter based on any live data values.

Reports can then generate files for HTML web pages, Acrobat Reader PDF files, Microsoft Word RTF files, Graphic TIF files, text files, or even directly to the default system printer.

Refer to the Report Designer application help on how to create a report.

Refer to the Videos – Reports Section for a walk through of the Report Designer and setup of sample report.

Report Designer

Report DesignerThe Report Designer can import Crystal Reports, and Microsoft Access Reports, and has an easy to use editor and wizards for creating reports in just a few minutes.

Use the Calculated Fields like Avg, Min, or Max for performing statistics on the data.

Configure-Reports

Configure ReportsTo open a new window for assigning Report execution methods, select Configure-Reports or Alt-C-R.

Select a Windows Service to modify, the node with the green arrow is the current Service being modified. Refer to Selecting Service for more information on selecting an OAS Service.

Add Report

Add ReportTo add a Report to the Service enter a unique Report Name and specify all other parameters as desired, they can be modified later. Use the Add Report button on the Menu Bar or the Add Button at the bottom of the window.

Delete Report

Delete ReportTo delete a Report of the selected Service select the desired Report in the center column and perform one of the following:

 

  • Right click on the Report and select Delete.

Delete Report 2

  • Use the Delete key on the Keyboard.

Modify Report

Modify Tag 2To modify an existing Report simply select the desired Report and make the modifications in the window followed by Apply Changes in the lower right corner.

 

Report Common Properties

Report Common Properties

Report Name

The name that identifies the Report in the Report configuration.  This name appears in System Alarms if there is a failure with the Report.

Reports CSV Export and Import

All reports groups can be exported to a CSV file by right clicking on the Local service and select Export CSV.

Note: You cannot have Excel open with the CSV file during the import as Excel will lock the file for exclusive use.  First close the file in Excel, and then proceed with the import.

Report Query String

Use the Query String property or Set Query String with Tag to filter data based on your own criteria.

Manual Report Generation

You can use the Report Viewer application to manually view and create reports. This is found under the program group Open Automation Software.

Reports Programmatic Interface

Use the OPC Systems component in your Visual Studio application to programmatically modify report groups. Refer to the FormConfigureReports Form in the WinForm Example Code example for an example and how to add and modify reports groups.

Refer to the Programmatic Access Reports section in the Programmatic Interface – .NET Programmatic Configuration topic for all of the method syntax.

More: