GitHub - ariacom/Seal-Report: Database Reporting Tool and Tasks (.Net) (original) (raw)

Seal Report & Task offers a complete framework for producing daily reports from any database or any No SQL source, and to perform complex tasks.

The product focuses on easy installation and report design: Once setup, reports can be built and published in a minute.

Seal Report & Task is an Open Source tool for Microsoft .Net entirely written in C#.

Main Features

• Dynamic SQL sources: Use either your SQL or let the Seal engine build dynamically the SQL used to query your database.
• LINQ queries: Join and query any Data Sources (SQL, Excel, XML, OLAP Cube, HTTP JSon, etc.) with the power of LINQ queries.
• Native Pivot Tables: Simply drag and drop elements directly in a pivot table (Cross Tab) and display them in your report.
• HTML 5 and ScottPlot Charts: Define and display Chart Series in two mouse clicks (Support of ChartJS, NVD3, Plotly, ScottPlot and Gauges libraries).
• Fully Responsive and HTML Rendering using Razor engine: Use the power of HTML5 in the report result (Bootstrap layout, Responsiveness, Tables sorting and filtering). Customize your report presentation in HTML with the Razor engine parsing.
• Excel and PDF: Have a full control of your report result in Excel (use of EPPlus library) or PDF (use of QuestPDF library). Several other formats are available (XML, Json, Text, CSV) or can be easily customized.
• KPI and Widget Views: Create and display your Key Performance Indicators in a single report.
• Web Report Server: Publish your reports on the web (Support of Windows and Linux OS with .Net Core).
• Report scheduler: Schedule your report executions and generate results in folders, FTP, SFTP server or send them by emails (integrated with the Windows Tasks Scheduler or available as a service) via SMTP, SendGrid or MS Graph.
• Drill Down navigation and Sub Reports: Navigate in your report result to drill to a detail or to execute another report.
• Report Tasks & ETL: Define tasks to perform your ETL or batch operations (data load, excel load, file download from FTP or SFTP, zip, backup, data processing, etc.) or to trigger procedures from external assemblies.
• Low TCO (total cost of ownership): The product is designed for minimal ongoing maintenance.
• NuGet packages to ease integration into existing projects.
• Native support of Mongo DB.

A live demonstration of the Web Report Server is available.

Quick start guides for building reports are available at the Seal Report Web site.

Use the Github Discussions to get free support, information and hints on the product.

Screen shots

HTML Report Result

Report Designer

Web Report Server

System Requirements

For use:

• .Net 8.0 (Microsoft Windows Desktop Runtime 8)
• Database OLE DB, ODBC, MS SQLServer, Oracle, MySQL, SQLite, PostgreSQL, Mongo DB Drivers
• For the Report Designer: Microsoft Edge WebView2
• For the Web Report Server: Internet Information Server with ASP.Net Core Runtime 8 (Hosting Bundle) or greater

For development:

• Visual Studio 2022

License

Seal Report follows a dual-licensing model to ensure its maintenance, quality, and support.

More information at https://sealreport.com

Supporting Seal Report

Seal Report is an open-source project maintained by Ariacom.
You can support its development and sustainability in several ways.

• License Purchase: The simplest way to support the product is to purchase a license at Seal Report Licenses.
• Consulting: If you require professional consulting, training, or workshops, please contact Ariacom.
• Sponsoring new features: If you need a new feature that could also benefit the community and become part of future product releases, you may sponsor its development. Contact us at Ariacom.