I spent 4-5 hours or so in various forums and on my websites, studying reporting tools that can help me in my development. I am new to using such tools and can use some specific recommendations.
I am working on a web application that will be hosted on a single server, but accessible by multiple users via login. Each user will have their own account and can only access reports that relate only to their data associated with their account. The site will have from 1,000 to 5,000 accounts (which may eventually have 2,000 - 10,000 users working with various reports).
My environment: OS: FreeBSD Web server: Apache Database: MySQL Programming languages: PHP, javascript (jquery and my own materials)
The Business Intelligence reporting tools I spent most of my time were: Pentaho Suite BIRT Suite JasperSoft Suite
My WebApp must support multiple languages in the report. I read that BIRT and Pentaho offer multilingual reports, but I can’t think of JasperSoft. Some reviews said they used Pentaho and included JasperReports (which, I assume, was a professional product for $ 249 ... the reviews didn't say that, but now on their website).
So here is my question. With your experience that you would suggest in my situation? I want to present 40-50 different reports that a user can view on the Internet, with charts, in several languages, based on their account information, and then if they want to set a schedule so that these reports are sent by email every week, month , etc. in pdf, xls or something else ... to whom they point ... webApp will do this automatically. It would be nice to let my users dynamically create their own reports and save them as well. I don’t want the system to fit in with these reports, most of the data is simple ... there will be some need for aggregate data, but it will not be too intense SQL ... two, three tables are joined or less. I want as little learning curve as possiblesince I'm new to these types of reports, so which package has the best documentation / smallest learning curve using the most convenient tools?
, BIRT 100 , Pentaho , JasperSoft . , , , ? Pentaho, jasperReports, , , ?
, ... , , 2-3 ... .