Seal Report is an Open Source reporting and dashboard platform for the Microsoft .Net Framework, entirely written in C#. It is composed of the Server Manager application, the Report Designer application, the Web Report Server and the Task Scheduler. The Server Manager application edits repository Data Sources, Devices and is used to perform administrative tasks (checking sources and reports, publishing web site). The Report Designer application edits and executes reports. The Web Report Server (a MVC4 Web application published on IIS) allows the end-users to execute the report published from the Web, and the Task Scheduler (a console application) is invoked by the Windows Task Scheduler to schedule report execution on a Device (folder or email).
A report is composed of Data Sources, Models, Views and optional Tasks, Outputs and Schedules. The report may also reference Views Templates and Themes located in the repository. Data Sources contain the descriptions of database connections, tables, joins and columns. Models are used to generate ResultSet (Data Table) and Series from a single SQL Statement. The Views are used to generate a HTML document from the Models using Razor parsing and rendering. Output and Schedule may be defined to automate report generation. Tasks may be defined to perform basic SQL or Script tasks.
Other features include:
Dynamic SQL sources: Use either your SQL or let the Seal engine build dynamically the SQL used to query your database.
Native Pivot Tables: Simply drag and drop elements directly in a pivot table (Cross Tab) and display them in your report.
HTML 5 Charts and Microsoft Charts: Define and display Chart Series in two mouse clicks.
HTML Rendering using Razor engine: Use HTML5 in the report result (JQuery Tabs, Tables sorting and filtering). Customize report presentation in HTML with the Razor engine parsing.
Web Report Server: Publish reports on the web (requires Internet Information Server 7 or 8 with MVC4)
Task scheduler: Schedule report executions and generate results in folders or send them by emails (integrated with the Windows Tasks Scheduler).
Deployment environment:
Windows XP, Vista, 2003, Windows 7, 2008, Windows 8, 2012
.Net Framework 4.0
Database OLE DB or ODBC Drivers
For the Web Server: Internet Information Server version 7 or 8 with MVC4
For the Task Scheduler: Windows Vista, 7, 2008, 8 or 2012
Development Environment
Visual Studio 2013 with MVC 4
Support, training and consulting can be got from Ariacom.com. This also gives access to extra features such as integration of reports in applications without source code disclosure and a PDF and Excel converter.