Reports - Tabular vs. MSRS Reports
Tabular reports are calculated by the OpenData software and its connection to the SQL database.
MSRS reports are calculated through Microsoft Reporting Services which has its own independent connection to the SQL database.
Because of the fact that there are two different connections to the SQL database and two different programs doing calculations, it is possible that some reports will work and some may not. If for instance the MSRS configuration was incorrectly edited, the Tabular reports would continue to function properly.
The following picture shows all of the available reports.
For the most part, reports with the following icons are MSRS reports.
The reports with the following icons are Tabular Reports.
The best way to tell which type of report it is, is by checking the configuration page.
The configuration page for MSRS reports looks like the following.
The configuration page for Tabluar reports looks like the following.
Related Articles
Reports - Configuration Documentation
Attached: Report Configuration and Operation Guide Attached: ReportLaunchingTable-v1Reports - Data Source String
This is what the Report Data Source string should look like. Data Source=localhost;Initial Catalog=EEDBSQL Server - Changing Database Location / Server
When changing database location / server you will need to update the following files and tables. In the Opendata file structure: database.properties - contains database connection info - Located: C:\Program ...What is the OpenData Collector?
is the Windows based data collection application that provides communication with devices, normalizes the data and reports the data back to the main OpenData application. Communication with the main application database is encrypted. (Blowfish) ...PowerWare Modbus Card