Jaspersoft Reporting and Analytics for AWS

My main use case for Jaspersoft  is operational reporting. It's a fixed pixel-based, pixel-perfect reporting solution. For any tabular reporting and canned reports, it's a very good tool to implement. It has a strong web application called Jasper  Report Server which is quite useful in terms of hosting the reports and distributing the reports across different pathways, such as sending it to specific system drives or through users via emails.

At the same time, the very important feature of enterprise editions of domain designs allows end users to have self-empowerment to create reports on their own. This approach reduces about half of IT implementation effort if there is a logical layer in place, so that any ad hoc analysis can be done by users without any technical knowledge.

I can give you a specific example of how I use Jaspersoft  for operational reporting in my bank client. I wanted to understand client positions as of today and what client positions are available for the finance team. What we have done is connect transactional systems data that flows into an operational data store. We connect to that operational data store and have implemented a report requiring all the key attributes which indicates the client portfolio data and the client positions data. We are sharing that with finance, which is used by them for their internal analysis and accordingly, they use that for external submissions in their different formats. This is also one of the key reports that they use for their analysis.

I have something else to add about my main use case for Jaspersoft. We have quite a lot of domains that we have built, which are logical layers, especially on CRM  which is customer data. Also on ODS, which is a very important data set that is our core banking transactional data. There is another important logical layer that I have built called CLIP, and it's more related to client pricing data on how we can charge clients and how it is being charged. Any charges that have happened in the upstream applications, if end users or business side of CLIP want to see the charges instantly and do their analysis, whether it is rightly charged or any incorrect charges levied, or if there is any less charge happened to the client where the bank is losing money. They will get to have instant analytics done using these logical layers and build their own ad hoc views with different fields and parameters in place dynamically. This will give them a clear idea of how the pricing strategies are going on and any changes in pricing strategies to be taken up.

One of the best features Jaspersoft offers is the virtual data source-based reports development, as well as virtual data source-based domain implementation. This has been available for almost more than ten years. I don't think any tool would have such a great functionality of writing a query from multiple data sources, bringing data from multiple data sources, and keeping it into one. Many warehousing tools might have it, but you still need to connect to a single data source for your reporting. However, in Jaspersoft, you can create virtual data sources directly in the server and you can have direct SQL queries on multiple databases and then develop reports. This is one of the very nice features that I see and also in terms of interactive dashboarding, with HTML5 charts compared to the heavy licensing costs of the on-demand tools, this licensing-wise is quite cheaper and the features that it offers are quite good compared to other tools.

I can tell you more about how I use the virtual data source feature. CLIP contains the pricing data, whereas the main RM for a portfolio has a relationship manager who handles that particular portfolio and pricing-related charges for the respective client. All the pricing data comes from CLIP application, whereas all the portfolio RM relation will be coming from a different application called CRM , where we have the customer data as well as the RM data, and the pricing data sits in CLIP. What we have done is create this logical layer with the combination of CRM and CLIP, wherein CLIP business can get to see who is the RM, who is the RM in charge of this particular portfolio and how the pricing strategies are being maintained, how the charges are being maintained can be viewed at a single place using this logical layer with the feature of virtual data sources.

Jaspersoft has positively impacted my organization. For the operations team inside the bank, they do a lot of MIS (Management Information System) reporting on all the transactions happening. One of the specific reports is a transactions payment report where they want to find out how the funds are being transferred, what are the charges made by the bank, and if the charges are happening correctly. All the calculations which are used by our internal teams for their analysis, and then they submit to the regulator based on their analysis on all the transactions related information.

I can share more about the impact. Earlier, when we didn't have Jaspersoft, even in the current world, there are teams, especially even in operations, that are implementing a lot of reports in Excel and doing all the calculations and after that doing their analysis using Excel itself. Once Jaspersoft is used, we have automated their manual activities and saved literally almost everything. Previously, they usually took one and a half weeks to prepare a report for their analysis. Now it takes less than two hours because we have automated everything and they get their report into their hands. They just use the data that we provide for further massaging and finish their analysis. This saves literally one week plus it saves additional time.

Jaspersoft can be improved in several areas. I think this is a very interesting question with feedback for the product teams. Recently it was acquired by HCL, an Indian service-based company. I feel disappointed with the way it is being handled by the respective company that acquired TIBCO Jaspersoft . When TIBCO owned Jaspersoft, it was really good, but after TIBCO acquired it, I feel the marketing strategies or the product implementation roadmap is not up to the way that I have expected. I have personally logged a couple of product defects and very important features as an active user and had to get those features implemented myself.

Documentation certainly requires improvement in terms of setting up Tomcat  and how specific environment-related instructions are provided, including JVM settings or setting up source profiles. If the basics can be included in the documentation, it would be much better. Additionally, some of the core installations are not happening in Jaspersoft from the last two versions, version eight and ten. Considering the default product issues, when you install, some of the default config files are not getting generated properly and we have to manually change the files and make sure the installation is working fine after that, which is supposed to work fine with the product. The documentation has to be improved in terms of any bottlenecks. If any issue comes, there should be guidance on how to fix it as this is part of the core installation.

One important feature I expect is that though the import and export features are given, they are not working for heavy sizing repositories. My current repository is around close to one terabyte plus and we have a great challenge in getting that entire export into one single export. This is not happening. The kind of storage requirements that we have, even if we have increased the storage requirements, the process runs for eight hours, and if any halt in the system occurs, the entire process gets stuck and everything has to be redone. I have raised a product feature to implement a date-based, a date and time-based import and export facilities. That way you can always take some cut of the data for export and import the same cut of the data for import, which gives greater flexibility and immense balance for production rollouts, especially wherein you cannot have an entire production system down and migrate the entire data into the next system. It will always be like one month or two months prior to export all the prod data into a new system. But that will still be two months delta. As there is no provisioning of two months delta to be taken with date time feature as such, we end up doing manual exports from UI for that particular duration, or we need to redo everything back again. This is a great deal of effort that gets invested in doing these import and export activities.

I have been using Jaspersoft for around fifteen years. Even in the current field it's ten years, and in between, I have used a mix of Tableau and Power BI, but Jaspersoft is always continuously on one side.

I would like to add something else about the features. The licensing cost in terms of what it provides is notable, especially in terms of it does provide web services as a data source, but I wouldn't characterize it as a drawback. They have perceived it as an open-source project. I would feel that if they can take this up as a proprietary project under product development, this would certainly give a huge mileage compared to custom Java implementations or custom Python implementations to use REST or SOAP-based web services. This would give more provisioning for many of the users to have web services as a data source in Jaspersoft. Another important functionality or features for migrating one environment to another environment is seamless import-export facilities and the kind of repository management and security in terms of roles and users that are tightly coupled. This gives you a great balance and flexibility to manage all the repository permissions intact. You can have all auditing enabled. Product implementation-wise, everything is good. You have auditing enabled. If anybody is touching the Jaspersoft server application illegally, or without proper access or without proper approval if somebody is trying to change any of the report aspects, that will be captured under audit as part of the Jaspersoft product feature itself where it will have robust security as well that way. Overall, I would rate this review at seven out of ten.

In our organization, the main purpose of Jaspersoft  is for reporting purposes, and that's where we usually schedule and send the reports to the user for their business.

The main thing I appreciate about Jaspersoft  is the ease of creating reports; it's very straightforward. When we need to create custom reports with a query, we can directly go to Jasper  Studio, develop the report, write the query, bring that data, and develop the report in any way we prefer.

The second thing is regarding generating the report from ad-hoc views; it is very straightforward. We just need to drag and drop the columns we need for developing the report, and with that, we can schedule it and generate the report. If we want to develop a custom report using the query, we can develop it easily, and we can format it as we prefer. Generating reports with ad-hoc views is very easy; just drag and drop the columns and apply the necessary filters as defaults whenever the report is executed, which is a very good aspect of Jaspersoft.

I have worked on both generating a report using ad-hoc views and writing a custom query in Jasper  Studio to design and publish it in Jaspersoft. Generating the report from ad-hoc views is the most suitable option for me; it's the best path to take.

The main dislike about Jaspersoft is the latency issue; sometimes when the report is generating, it takes more time than expected based on the report. For example, the project management tool I'm currently working on has the OBS, Organizational Breakdown Structure, and whenever Jaspersoft query fetches this OBS data, it takes more time than we usually expect. The user is somewhat hesitant about this issue; when the report takes so much time, the user gets annoyed. If Jaspersoft could fix the latency issues, it would be a good tool for anyone to work with.

Regarding lagging, whenever we generate reports on large data like OBS data—which is the hierarchy of the organization—Jaspersoft sometimes experiences delays. The latency issue is apparent when pulling this data. Additionally, when developing a report from ad-hoc views in Jaspersoft and specifically when scheduling it, the scheduling doesn't always work as expected. Both the latency and scheduling parts can be challenging in Jaspersoft.

I have four years of experience working with Jaspersoft.

The initial deployment of Jaspersoft is very easy; it is not difficult at all. If you go through the deployment steps we need to follow, it's straightforward with nothing much complicated.

From start to finish, it almost takes one hour. Jasper installation will not take more than fifteen minutes. When the build starts, it should not take more than twelve minutes. Before that, we need to set the Java path and home along with the environmental variables, which takes some time, including installing the installers from the appropriate site, unzipping it, and setting the environment variables. I believe it will take around thirty to fifty minutes to complete the installation. After that, we need to make some changes in the application.properties file, where we incorporate our server details, and this process won't take more than one hour.

One person can do the deployment; it's not a big task and is very easy. The only thing required is awareness of how to get it deployed. Once you understand the steps to deploy, one person can handle Jaspersoft installation alone in the system.

Pricing-wise, I haven't had much chance to see how much budget has been allocated for Jaspersoft, but it's not disclosed to anyone; it's completely managed by the client.

For our organization, we need to take care of Jaspersoft maintenance as well. Google Chrome, the version compatible with Jaspersoft, is vulnerable to threats, so we usually install Google Chrome into Jaspersoft every month. Also, sometimes the Apache Tomcat  version is vulnerable, so during that time we feel the need to install an upgraded Apache Tomcat . Those are the two maintenance tasks we regularly perform. I would rate this product seven out of ten.

My main use case for Jaspersoft  is that we inherited a legacy application that used Jaspersoft . A quick specific example of how I used Jaspersoft within that legacy application is that we would have batch jobs that generated reports for accessories.

Jaspersoft can be improved by having better documentation, better support, upgrading the UI of the tool, and integrating other programming languages, not just Java.

In my experience, the best features Jaspersoft offers were not the best. We ended up migrating this legacy application to a completely new tech stack in Python.

The challenges or issues I faced with Jaspersoft that led to the migration include the fact that the tech stack is deprecated and it was very troublesome to upgrade the Java version. Additionally, there was no integration with Python, so we ended up rewriting the whole thing in Python. We still use the JRXMLs for the reports, but we are not using Jaspersoft system for Jaspersoft Studio or anything else.

The thing that was particularly frustrating with Jaspersoft was that the code being generated was not exactly following coding standards. A lot of the exceptions were very generic, such as exception one, two, three. It does not have great integration with other systems, which was one of the main reasons that led to the migration. We also struggled with learning how the system worked, and there is not much intuitive documentation or support for that matter.

The needed improvements for Jaspersoft include better big data support and integrations with something such as Hadoop  or Apache Spark .

I have been using Jaspersoft for roughly about two years.

In my experience, Jaspersoft is not stable, and it does not have good community support.

Jaspersoft's scalability is not very good. I ran into issues scaling up or down.

The customer support for Jaspersoft is basically non-existent. I did reach out and did not really hear back.

I did not previously use a different solution before Jaspersoft. Jaspersoft was the first one, just because that is the one we inherited, and then we migrated to Power BI.

My experience with pricing, setup cost, and licensing for Jaspersoft indicates that installation was a pain, licensing is not worth the money, and there is no AI integration that I have seen. That is another thing that should be implemented or enhanced.

I have not seen a return on investment from using Jaspersoft; not a single one, hence why we are migrating.

My experience with pricing, setup cost, and licensing for Jaspersoft indicates that installation was a pain, licensing is not worth the money, and there is no AI integration that I have seen. That is another thing that should be implemented or enhanced.

Before choosing Jaspersoft, we did not evaluate other options. It was just inherited.

I would rate Jaspersoft overall as a two on a scale of one to ten. I choose that number because of the poor integration with other systems and the performance enhancements that we experienced during the migration. Jaspersoft batch ETL was very slow. My advice to others looking into using Jaspersoft is simple: do not use it. Use anything else instead.

I work on Jaspersoft  to create invoice generation for pick-pack slips and order slips that are generated once payment is completed in e-commerce applications.

I use bands in Jaspersoft  and map JSON to fields using parameters, variables, and expressions. I utilize loops to generate boxes and employ seven bands including headers, body, and footer to generate the slips.

I use Jaspersoft to generate PDF, Excel, and Word documents, which supports salary slips, invoices, and student reports while fetching data from MySQL  databases. I designed dynamic reporting using inputs and date range selection to generate reports and create pie charts and bar charts from data. I use Jaspersoft in enterprise applications built with Spring Boot  Java, where users can download reports in CSV and PDF formats. I configured these features using Java libraries, which significantly reduced effort in report generation. I also implemented Jaspersoft in microservices within the reporting module. I use common components such as core Java libraries and Jaspersoft Studio to design reports. Jaspersoft Studio provides drag and drop tools for report creation.

Jaspersoft's powerful features include the ability to generate reports in multiple formats such as PDF, Excel, Word, HTML, and CSV. The main advantage is the ability to integrate and connect databases with Jaspersoft, whether using MySQL  or NoSQL databases. I can easily integrate databases with Jaspersoft software.

I can generate dynamic reports using parameterized reports, which auto-fetches data. I can design reports using drag and drop functionality on the user interface, where I can drag fields, tables, images, bar charts, and tables. I can generate charts in various formats including bar format, pie chart, line chart, and area chart, which allows for easy data visualization.

The main feature of Jaspersoft that I value is sub-report generation, which separates concerns easily and merges with the main report where I write logic. For example, if the main report is about an employee, I can generate a sub-report of salary details, which is very useful. Jaspersoft provides reusable templates in the form of JRXML files that I can use throughout the application multiple times. It provides high performance for large data, security features, and role-based access control configuration over slip generation.

I can integrate Jaspersoft APIs in Spring Boot  Java applications and apply custom styling including fonts, colors, and layouts to create professional-looking report generation. These are the features that I valued using in Jaspersoft report generation.

The UI and UX of Jaspersoft could be improved as it feels outdated or complex, and enhancement is needed to make it easier for users to utilize more features. I would suggest adding AI features to Jaspersoft and implementing suggestions so users can easily leverage all the features in the application. Using expressions in Jaspersoft was somewhat tricky, and reducing unnecessary complexity would help me leverage expressions and write them more easily in reports. For large data, there are performance issues where reports are slow to generate in the final design, and optimization is required.

The UI could be improved with enhanced real-time analytics capabilities as the current UI is not very good. I would recommend adding enhancements so users can leverage all features in Jaspersoft and incorporate advanced integrations with microservices and cloud, which would be more helpful. Jaspersoft is not very useful for mobile and is not particularly responsive. I would suggest designing responsive support to improve Jaspersoft for Android applications.

I would recommend improving the user experience and adding AI features similar to Tableau and PI. Advanced features should be improved to support microservices and cloud features while facilitating easy integration. For large data, performance is slow, and I would recommend improving that particular aspect for large performance data. The band UI is very compact on the screen, and data cannot be seen clearly while designing the report. I would recommend improving that particular part.

I have been working on Jaspersoft for two and a half years.

Jaspersoft is stable.

Jaspersoft's scalability is very good, and I can introduce new features into it.

Customer support is very nice and very helpful.

Jaspersoft is provided by my organization, so I use it. I am not aware of the pricing and setup cost as I leverage it through the company.

Jaspersoft has significantly reduced a lot of time, and the user is very happy. The client is also very happy to see report generation happen very quickly, which has effectively reduced the time of report generation and is very useful. We have been using it for a very long time, approximately thirty years, which demonstrates its value.

For some reports, the creation of template design was taking eight hours, but using Jaspersoft, it can be done within two hours, which is very impactful.

I appreciate sub-report generation in Jaspersoft because I do not need to write entire logic in the same report. I can generate a separate sub-report, which makes it easy to manage tasks and data and easily generate a template design. Once the final design is complete, I can merge it with the main report.

Based on my understanding, I have included all the points I have used regarding Jaspersoft. I particularly appreciate the security features such as role-based access control at the data layer. Another feature I appreciate is the ability to reuse templates that I have created in other reports. I can also visualize data using charts and graphs by simply using drag and drop and configuring the data.

I would advise using and utilizing the features of sub-report generation and main report generation in Jaspersoft. I can also easily integrate it with the Spring Boot application and encrypt and decrypt data in the form of Base64, which is a very good feature that I can leverage.

I would rate this product seven out of ten.

My main use case for Jaspersoft  is developing reports, the KPIs for the clients, and different visualizations for their daily metrics, monthly metrics, and yearly metrics.

One of the reports I developed for a client using Jaspersoft  is the capacity versus allocation for a particular organization, department, or on a particular project or task. The project storyboard shows how the project is going and what risk issues are associated with that. Similarly, the project detailed report provides much more detailed information that clients want to discuss with team members and follow up with the required stakeholders.

My favorite thing about how Jaspersoft handles data and visuals is that it is easy to connect to other systems. You can use SQL queries, and the visualizations are also good, meaning that table visualizations or weekly reports are straightforward. If you want something advanced like bar graphs or pie charts, all those things are also possible using Jaspersoft. In addition to that, you can build ad-hoc reports on Jaspersoft.

Regarding ad-hoc reporting, my team uses that feature often, and it helps speed up our workflow and decision-making. You do not need to reach out to the developer as you have the required tables available to drag and add your own KPIs, metrics, columns, whatever you need, and see the information right away to take decisions based on that. It speeds up the process.

Features of Jaspersoft that stand out to me include how easy it is to build reports, scale, and maintain them. I have not seen any major issues while building these reports, and I think even complex reports can also be built easily.

Jaspersoft has positively impacted my organization by adding more visualizations, and it has started using the latest technology based on Java versions. The visualizations and updated technology have improved my team's productivity and decision-making tremendously. You can see the storyboards and metrics on a monthly basis, identify where we lack, what is causing the issues, how the revenues or sales can be improved, and how expenses can be reduced. All these things are done through Jaspersoft.

Jaspersoft could be improved by innovating features, especially with the new competition coming up from Power BI and everything, perhaps by enhancing the drag-and-drop feature. It is easy to build with Jaspersoft, but there could be more features.

I suppose that even non-developers can build reports easily with Power BI and Tableau, but with Jaspersoft, while everyone can do ad-hoc reporting, only developers can work on complex reports. That is where I feel improvements can be made, allowing a non-tech person to start building reports as well. The only improvements needed for Jaspersoft are enhancements to the features, allowing more non-developers to start developing.

I have been using Jaspersoft for more than twelve years.

Jaspersoft is stable in my experience as we have been using it for the past twelve years. We have not faced any problems with Jaspersoft. The installation and upgrade steps have been straightforward and everything has been smooth, so I do not think we had any problems with Jaspersoft.

Jaspersoft's scalability is good; we have seen clients developing multiple reports, maybe even fifty or more reports using it.

I have seen a return on investment from Jaspersoft, and relevant metrics include time saved and money saved. For example, some clients looking at the reports save ten percent on expenses, and time spent is also saved as they identify gaps and everything that can be improved.

My experience with pricing, setup cost, and licensing for Jaspersoft indicates that the pricing feels on the higher side when compared to Power BI or Tableau. I think a reduction in pricing would help.

My advice for others looking into using Jaspersoft is that if you are looking for reports, then I think Jaspersoft would be the go-to solution. I really appreciate Jaspersoft, and I have been using it for the past twelve years, so I think anyone who wants to go with this tool should just go for it. I provided this review with a rating of eight out of ten.