I am looking at using a web report project as an alternative to SQL Server Reporting Services. For the most part I think it will be a better and more flexible solution. One feature that I have not come across is a way to schedule the report execution and distribute it via email to a list of recipients. Is this possible? Another issue that I may come across is the ability to export to Excel. From what I can see this is not currently available. Is this possible?
Using the BIRT API, you will be able to programmatically generate reports and email them to clients. Exporting to Excel sheets is also possible, it’s an option within the BIRT report viewer so this too should be possible programmatically.
Our reporting solution is gearted towards the development of a reporting web project where users can use a Web based interface to request and view reports – we do not have any wizards that would assist with scheduled report generation or direct use of the API, but all the API and libraries will be accessible to you within a reporting web project. The implementation of that would be up to you.