Jaspersoft Reporting and Analytics for AWS

I explored Jaspersoft  as part of my experience while looking into my current work schedules and was eager to explore new technologies and tools to understand what capabilities they could bring into our current initiatives we were taking on in the projects or maybe the new innovations.

Jaspersoft  is definitely useful for generating customizable reports on your application itself instead of redirecting the users to some other third-party tool. So for generating the reports, it is definitely a very good platform.

This was basically part of my initial self-analysis and exploration that I was conducting. I generated a couple of reports on how frequently the user traffic was coming, some reports regarding the claim success rate, claim rejection rate, and also the count of the users that were landing on a particular page, how much traffic was coming, and how frequently they were shifting to the other or navigating to the other pages inside the applications. I also generated graphical reports as well. If someone is looking for generating lucrative reports that are pixel perfect along with graphs, it is really helpful.

If someone is looking for it, the kind of perfection Jaspersoft is bringing in is a real example and exploration for the end users. The report structure, the look and feel, the scheduling, the deep embedding, and also the precision that it brings to your report really matter a lot. For example, even if we are trying to generate a heat map or a bubble chart or normally a pivot graph, it helped a lot.

There are definitely lots of features. If you just use it and even if you want a playground for data sciences to explore the trends, you might look elsewhere, but Jaspersoft is definitely bringing a good perspective in terms of making a precision report with pixel-perfect quality. Most of the BI tools have flaws with data dynamically, which breaks a strict layout, but Jaspersoft Studio gave us absolute control over the horizontal and the vertical coordinates, the X and Y axis, ensuring the PDF output looked identically similar every time. The deep embedding feature is also valuable. For example, with the real-world explanation and visualizing the D3.js  code that was integrated on Jaspersoft dashboard itself on their SaaS platform, the users never even knew that they were looking at a third-party tool. If you embedded Jaspersoft into your application, it just seems like the reporting is part of your application and you are not navigating to some other external third-party tool. We also use a server to automate the weekly report generation, and in that case, it is really helpful.

Since I explored it as a part of my self-exploration of the different technologies, it brings a lot of positive aspects and bringing the reports on the table with respect to the matrices or the criteria I was looking for, even above the expectations. Though I agree it takes time to get the reports done and needs some hands-on experience on that, but the quality it is bringing and it is not creating any kind of deviation for the user. The end user should not feel that they are navigating to some third-party site or the other platform. It is embedded in your application on its own to have a seamless experience throughout the entire journey.

Every platform has its own way of working and definitely there is always a room for improvement. Jaspersoft is the same. I find that there is a good space on the learning curve, which can be decreased with proper documentation because if someone is a seasoned developer or a seasoned professional, it is easy to have the knowledge and the kind of reports they want to bring with Jaspersoft, but if some new learners or newbies are there, then definitely there is a learning curve on this. Additionally, on the licensing side there is a commercial and the enterprise license. You need to see which one suits you better and should not overpay it unnecessarily if it is not needed. The documentation gap is also there, so I would still recommend that the documentation can be much more emphasized, standardized, and have something specifically about the integration on the coding side, like how you should need to configure the things. That is where the documentation can be enhanced.

I would say maybe on the performance and support size because if you are running it on the server, sometime the UI might or the report may take some time to refresh data or get a delayed response, and that is where things can be improved. If someone is looking for a seamless experience, they can definitely go for Jaspersoft. But if they are looking for a quick building of the report with drag and drop facilities, then there are some other tools for the report generations, quite easily. They can opt for that instead.

For Jaspersoft, scalability is where it definitely shines in. We were working on different multiple reports against a data set over thousands or hundreds of records. By using its JSON data integration, it was easier to get all the data ingestion on the server-side filtering, then the performance remains stable even under the heavy load. It is really good.

As I mentioned, the licensing part is important with the enterprise and the community license. You need to see which one suits you better. Additionally, on the speed side, if you are running it on a server side, you need to see and balance the load accordingly so that the refresh rate should be high and should not have a delayed response. That is another point. One of the more core points would be the documentation gaps. The user interface that can be enhanced because currently Jaspersoft Studio feels like a bit using a tool from an early 2005 or 2010 version. With respect to the newer generation or the current era, the UI needs to be enhanced and the user experience should disrupt the other competitors in the market. That is where the improvement can be done.

I have been in my current field for more than eight plus years.

Scalability is where Jaspersoft definitely shines in. We were working on different multiple reports against a data set over thousands or hundreds of records. By using its JSON data integration, it was easier to get all the data ingestion on the server-side filtering, and then the performance remains stable even under the heavy load.

Customer support is really good on the community side. It just needs the documentation part and then it is good.

I did not switch. It was just a part of additional exploration and we were using Power BI and Tableau as well in multiple projects for the reporting and analysis.

I would not say it is easy to set up because definitely there is a learning curve if someone is going with Jaspersoft because it has the Visual Studio, XML integration. You need to have a good hands-on experience on your Java side and the XML side.

Somewhat, but not significantly. The reason is that it depends on the use case you are working upon. If you have a massive client with a good budget on your side, you can definitely go for Jaspersoft that brings the pixel-perfect in-house application, in-built integration with a seamless experience, that provide a good user experience to the user. Then definitely you can invest and it can increase your ROI. But on the counterpart, if you are looking for something that have much more lucrative UI features on reporting, then you can opt for the other tools as well.

Pricing again depends upon the needs and how you want to go for it. For example, one should definitely check before committing a full enterprise license and leverage Jaspersoft community edition. It shares some of the core engine capabilities as a paid version, allowing someone to test most of your complex report functionalities. If you want to run some kind of JS code or the XML or the SQL queries, you can check it out. Lay out your requirements and your vision or the innovations with upfront cost. Then if you think lesser cost is fine, you can go with the lower version. If you want the enterprise license, then you can definitely look into that.

I would be giving two pieces of advice. For example, if your needs are basically to generate pixel-perfect reporting with the precision on the values and the scaling it is going to bring, you can go for Jaspersoft. If you need deep embedding, if you want to visualize your JS, XML, or Java code with the heavy load of data sets you want to ingest it, you can use the data integration capabilities and the filtering capabilities of Jaspersoft. It will easily get in your data and can generate the reports on different sectors, wide range of reporting as per your needs and requirement. On the counter side, if you are looking for something that basically does not require the investment in time that working with Jaspersoft will definitely going to require, and if you do not have a seasoned developer on that side, you can go with other tools as well, such as Power BI and Tableau that can generate the reports pretty much quickly and give you a flexibility to integrate the third-party tools and then navigate your application over there or design a dashboard separately. My overall rating for this product is 7 out of 10.

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.