Projects

Our consultants and developers have delivered multiple projects in different industries in iReport. The impeccable understanding of the nuances in iReport graphical design interface and programming has helped us create multiple reports which were seamlessly integrated with the applications.

If you want to do Jasper Reprot development and need some help, get in touch with us today – call +1-248-686-1424 or email sales@mindfiresolutions.com or leave us a quick note – to leverage the strong track record and solid experience of our Jasper Report experts to bring your ideas to life.

  • Jasper Reporting API
  • Medical Business System (MBS)
  • Response Analytics
  • Recap Report
  • Jasper Reporting Solution
  • Jasper Reports
  • Jasper Report - Repeat Purchase
  • Selective Coordination Calculator
  • Distributor Purchase Status Report
  • Purchase Report System
  • Global Recap Report
  • Exception-Doors Report
  • Catalog Report


Jasper Reporting API

Client:
Global OnlineAdvertising Farm
Industry:
Online Advertising
Technologies:
Java, Jasper Report 4.5.0, IReport 4.5.0

This is a  Jasper Reporting API (Application Programming Interface) which can be integrated with any Java application. The Jasper report section consists of 10 individual subreports. All the subreports are designed in such a way so that they can act as individual reports and can be integrated with any jasper main report.

This API generates report as per the provided jasper report template which includes,
1. Multi-axis Time-Series Chart.
2. Multi-axis Bar Chart.
3. Detail Reports etc.
All the charts are customised with JFreeChart supported Java classes in order to achieve pixel perfect design. All the styles including Font, Color, Size etc are 100 % dynamic. This API comes with two already defined stylesheets but infinite number of stylesheets can be added and used to generate report.

The API is completely multilingual and can generate report lots of languages. The API tested with English, French, German, Spanish and Japanese languages. Internationalization is done using Resourse Bundle. Locale for a particular reports are passed as report configuration settings along with ReportOutputFormat (ie PDF / HTML)  and  ReportOutputPath.

This API uses JRDatasourse as the data source for generating reports dynamically. JRDatasorces are coded to fetch data from CSV files. CSV file paths are passed as report configuration settings. In the Jasper Report section all the Chart labels, Column Headers , Header Logo, Footer Logo etc are dynamic and passed as report configuration settings. In the Java side of the API all the required configuration settings are validated on runtime to check whether the values passed by the user are proper to generate report. In case the validation faila, it logs a proper message with the cause.


Medical Business System (MBS)

Client:
Servoy
Industry:
Healthcare
Technologies:
Jasper Report 4.0.0

Medical Business System (MBS) is a automated system which caters for all the invoicing and reporting needs. We have developed the entire reporting section and created over 40 Jasper reports. Below are the modules which includes reports:

Reporting: Balance, Balance Of BillTos, BPay Batch Report, Cr/Db Card & EFT's Summary, Daily Banking, Estimate List, Follow Up, GST Cash Report, Invoice Analysis, Monthly Statistics, Invoice Summary, Journals Charges & Reversal Summary, Payment Summary, Operator Performance, Prepayment Status Report, Re-Print Posted Bank Deposits, Trial Balance, Miscellaneous Reports.

Banking:  Deposit Lists, Quick Today, Quick Batch, EFT, EFT & BPay, Credit Card / Debit Card Deposits, Credit Cards Reversals, Batch and Batch Total.

Patient: Header, Page Of Labels.

All the above mentioned reports are created using jasper reports with data coming from Servoy side as Foundset. Huge amount of calculations and grouping are involved in all the reports.


Response Analytics

Client:
Financial services
Industry:
Commercial software development and technology
Technologies:
JAVA, Jasper Report 4.5, JFreeChart, SQL  Server 2008

In this project Jasper Reporting Tool was used to generate Jasper reports from JRXML  files. These JRXML files can be edited and customized as per given requirement .The Jasper design for the main report contains several sub-reports, where each subreport can also act like an independent report.

Features of the applications are listed below:

. Each of the report has Landscape page orientation
. Each sub-report is designed in such a way that they can act as an individual report and can be integrated with any jasper report
. Sub-report with line charts, pie charts and bar charts get dynamically generated based on the data source
. Sectional Hyperlink has also been implemented for different types of charts
. JFreeChart customization of jasper charts using java chart customizer classes
. All numeric, text, date and currency values are formatted and customized


Recap Report

Client:
Service  Provider
Industry:
Finance
Technologies:
Java, Jfreechart, iReport, Jasperserver, Postgres

The main report consists of 25 sub reports .The client requirement was to generate a Workbook of 6 sheets with the 25 report arranged in them in a manner that they should not have overlapping column or rows. There is a filtration on the number and type of sub report visible to the user based on user type. The charts used in the report were to be customized, for which we used java class to customize its label, formatting the data shown in the axes. The reports were then to be deployed in the Jasper Server. The jasper server has 25 cascading input controls (Dynamic input controls). These input controls are sent as a parameter to the reports.


Jasper Reporting Solution

Client:
Financial Services Optimization Company
Industry:
Commercial software development and technology
Technologies:
Report 3.7 and 4.5 ,Jasper Report,Netbeans,Jasper Server,SQL Server 2008

This project deals with the creation of reports based on the specifications and requirements of client, using Jasper Report building tool. The project has been setup on the client's computer and we need to work on that computer. To obtain the required columns from the database based upon the client's specifications one need to add SQL queries for datasets and sub datasets used in the Report.

There were scenarios when one needs to provide complete dynamism to the query used in the Report to obtain the desired dynamic resultset. The main task was to provide a design or UI to the text description provided by the client.

Designing the layout for the report incorporates the placement of the fields, coloring, dynamic changes keeping in mind, the specific designing standards set by the client. After the designing phase completes then we need to check the PDF and XLS exports for any discrepancy, as ultimately either of the two type would be utilized at the clients end.


Jasper Reports

Client:
Software Service Provider
Industry:
Retail
Technologies:
JAVA 6, Jasper Report 4.5, JFreeChart,  Infinidb, MySQL Query Browser

Worked on three reports such as MarketBasket Cross-Sell Analysis, Weekly Sales Analysis and SalesTrend. These three reports visualize sales related metrics. Market Basket Cross-Sell Analysis: How the sales of the base item is in baskets and what is the sales of other items in those baskets (whether cross-sell items or other items). Here basket refer to store. Also user can have option to switch between different time scales Daily/Monthly/Yearly basis.

Weekly Sales Analysis: Here the idea is to show what sales data available for the selected period (from both years i.e. current selection and previous year) and do the matching between the 2 years, comparing with week number & week day combination.

SalesTrend: The idea is exactly the same as in cross-sell report. Here user can change the dimension to be used against which selected metric like SalesMargin, Waste, Sales and NetMargin etc. is compared.

We have used Java to handle the core logic section and pass the result back to report. Also done some jFreeChart customizations like dynamically handle the time series based on date range parameter entered etc. Installed new font for this report as per client requirement.


Jasper Report - Repeat Purchase

Client:
Software Service Provider
Industry:
Retail
Technologies:
JAVA 6, Jasper Report 4.5, JFreeChart,  Infinidb, MySQL Query Browser

This project has a single report with two charts. One to display repeat purchase product details and other one for top ten repeat purchase items ratio. Used Java to handle the core logic section and pass the result back to the report. Implemented jFreeChart customizations such as dynamically handle the time series based on date range parameter entered and installed new font for this report as per client need.


Selective Coordination Calculator

Client:
Software Service Provider
Industry:
Electric/Power
Technologies:
Java 6, Tomcat 6.0.33, JSF2, Richfaces4, Java Mail API, Apache log4j, JASPER Report, MySQL 5.1

This web application is for use by electrical design engineers to design circuits to assist in selection of over-current protective electrical devices. Using this software, electrical engineers can design one line circuit diagram and calculate the circuit fault current and/ impedance against each component along with breaker selection to protect component from high current flow. Here user can design circuits on fly by using component(Utility, Generator, Transformer, Panel, Conductor, Breaker etc.) and its provided connectors. After that they can use the calculation button functionality of this application, where it will calculate fault currents along with their impedance, if any against each component.

Also application provides functionality for validating current circuit design for any missing connectors(links) and highlight the same. Once circuit is validated and calculated it will activate the breaker selection process from its downstream to upstream based  on current flow against its next consecutive Panel. At any point of time user can view the current circuit report in PDF format, where we have used JASPER report integration.

Also application will do auto save to keep the current circuit design, if session will expire at any point of time and display information about auto saved circuit while that user log-in next time to the application. Application will provide administrator and user account role. Administrator can design circuits and set them defaults, which will get auto generated when a new user register. Also there are features like copy circuit design along with make any circuit as template, so that it will help to start from any existing design and do the changes on that rather than design it from scratch.

Administrator can see all users activity as last logged in access time. Component library functionality also provided to both administrator and user account. Most of the features are handled by AJAX.


Distributor Purchase Status Report

Client:
Service  Provider
Industry:
Finance
Technologies:
JasperServer 5.0.1, iReport 5.0.1, PostgreSQL 8.4

The report creates to get the distributor status, monthly or yearly. It receives dates and other information from the user and calculates and sorts all data accordingly. It has three levels of report sorting according to region or country wise detailing which are interlinked querying the database accordingly.

The report shows the comparative table for different sales and purchase data. This report uses iReport 5.0.1 to generate reports in a required pattern. And Jasper Server 5.0.1 to link reports to each other.


Purchase Report System

Client:
Software Service Provider
Industry:
Finance
Technologies:
Jasper Reporting Tool , PostgreSQL

Here Jasper Reporting Tool is used to generate Jasper reports from JRXML  files. These JRXML files can be edited and customized as per user requirements. The Jasper design for the main report contains two sub-reports for the Global data, where each sub-report can also act like an independent report. Each of these sub-reports acts as a drill down reports and provides hyperlink to another two sub-reports which provides the details of the corresponding regional data. Features of the applications are listed below: . Each of the reports is built upon a Landscape page orientation. . Each sub-report is designed in such a way that they can act as an individual report and can be integrated with any jasper report. . All numeric, text, date and currency values are formatted and customized.


Global Recap Report

Client:
Software Service
Industry:
Finance
Technologies:
Jasper Report, Java, iReport, Jasper Server, PostgreSQL

To view data for sales, stocks, EOM, YTD sales/stocks, inventory of based on different parameter like gender, country, region, type, classification.

This report contains 25 sub-reports merged into a single master report. There are in all 5 sheets in the final document each sheet contains 5/6 sub-reports. Each sub-report is a complete report having its own parameter based data. The report was originally made with JFreeCharts with custom java code to modify the default properties and adding customized properties. Later the report charts were converted to HTML5 bar chart, pie chart, and stack chart.

This report is designed to be used in xls and xlsx format making sure that none of columns and rows overlaps for better visibility. The report contains cascading input control which means that one input control is dependent on the previous input control.

Global recap report with multiple sheets-Each sheets have 5-6 sub-reports based on some groups.


Exception-Doors Report

Client:
Software Service
Industry:
Finance
Technologies:
Jasper Report, Java, iReport, Jasper Server, PostgreSQL

To view store counts of all regions for the last 1 year depending on whatever date it was queried for .Also the each region can be drilled to a similar report containing its constituent countries.

The report contains all the regions as rows and last 12 months as columns showing the stores counts. Each individual region is hyperlinked to a report which contains past 12 months door count of the countries of that particular regions .The report is also having HTML 5 bar chart and Line chart .the bar charts shows the doors count for individual regions for the queried month. The line chart shows the door count of individual region in the last 12 months, where each regional line has a different presentation to differentiate visually better. We have used HTML5 charts for this report.


Catalog Report

Client:
Software Service
Industry:
Finance
Technologies:
Jasper Report, Java, iReport, Jasper Server, PostgreSQL

To see how different products have done business in the past 4 months in terms of Sales, Stocks, wholesale along with future 4 months sales of the product.

The report contains images of the products with their description and local market prices alongside the details of products business. The report is made mainly for PDF version. Two versions of the same report are made. One for classification and another for product story. Major complexity in this report was designing the report (because if the number of products increases huge it throws heap-space error) and SQL query (because of the variety of data stored in different tables and also keeping execution time in mind). The report contains cascading input control which means that one input control is dependent on the previous input control. Cascading input controls to get only the countries belonging to a particular region/sub Region. This report is also made for static version which means it can be called directly via URL. The parameters in this case is sent in the URL as key=values with '&' preceding the keys.


News & Updates

  • January 17

    DDM IT Quiz, Inspired by Mindfire, is Spreading its Wings!

  • December 16

    Santa in a different Avatar- International vacations gifted to All Mindfireans!

Let us Connect!

Awards and Achievements

Red Herringcolor DeloitteFast50 DB ZInnov1   Nascome  DB Stpi

This site uses cookies. We respect your privacy.copyright (c) Mindfire Solutions 2007-2018. Login