Seal Report is an open and feature rich database reporting tool. Users would be able to obtain the details necessary for reports about any database. After the initial set up getting reports published is easy and takes minutes only. Report formats can be designed easily. This is an open source product, written in C# for the .NET environment. This tool is able to build the SQL query necessary to find details. You could specify the SQL of your own too. The tool lets you create Microsoft style charts in couple of clicks, you need to simply drag & drop the data into them. Pivot tables can be built similarly by dropping data directly into the pivot tables. This application also lets you use HTML 5 to tweak tables, table sorting and filtering. The tool has built in Razor engine that could be used to parse the HTML5 statements.
A task scheduler available lets you execute reports and generate results in folders. You would be able to send these reports by email too. The interface is quite intuitive and just about anybody should be able to get productive with it in short time. The task scheduler works in conjunction with the Windows task scheduler that is built in. If you would like the reports could be published on the web, thatís possible too. You are going to need the IIS 7 or 8 installed along with MVC4. The environment need to be one of Windows XP, Vista, 2003, Windows 7, 2008, 2012 or Windows 8. .Net Framework 4.0 and database OLE DB or ODBC driver is essential. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.