Ability to link all types of reports under one 'hood'.
Open source.
Dashboard.
Ability to use Groovy to extend functionality (haven't tested this yet though)
I looked at uisng Report Server, Birt F-type hub, or JasperReports server. I ended up choosing Report Server as it was the only one that would enable to both use the BIRT reports I had already designed and working, allow me to extend to use various other reports (like Jasper), allow dynamic lists, and give a dashboard. To be fair, it looks and feels a lot like the Birt F-type, but without all the restrictions.
Getting the Report Server to use BIRT reports, my MySQL server, etc., was a breeze. It was literally only a matter of loading up the reports and they ran the same they did in Tomcat7, but perhaps a bit slower, which wasn't a problem for me. Using sql statement was also easy, just be sure not to include the ; at the end of your statement as this causes an error for some reason. Took me a little while to figure that out. Also, best not to include spaces in alias names, again, another bit of time to resolve that--with the help of the forum.
Flexibility - The system can be adjusted to needs of very different users: people who prefer self-service BI and ones that want predefined reports designed for them. This is particularly important for us as our company has many clients with diverse needs.
Support - The Team is present on the free forum. We have commercial support services and we are very happy about it, as if any problems arise, they are solved quickly. In this way we have immediate access to system and documentation updates.
Scripting and advances features - Many standard features can be extended through scripts written in Groovy. Script datasources allow to connect data coming from more than one database or to get data from websites, files etc. Script reports give unlimited possibilities - in terms of data processing and report lay-outs.
Templates - Dynamic list report allow to use jxls, velocity and xdocs templates. In this way we can create well-looking Excell reports (sometimes even with macros!), html reports with charts or serial correspondence in Word.
Automatically created reports' documentation
Datenwerke, accessible via their website at https://www.infofabrik.de/start, specializes in providing IT solutions and services. Based in Germany, they offer expertise in cloud computing, IT infrastructure, and data management. Their services are designed to help businesses optimize their IT processes, improve security, and enhance operational efficiency. They focus on delivering tailored solutions that meet the specific needs of their clients, leveraging the latest technologies and industry best practices.