Category Archives: Report

Collection of Solutions to Knotty Report Building Problems

There are many knotty problems around report development. These include complex layout, which is difficult to build with a reporting tool alone; complex data sources requiring dynamic access and involving different types of databases or non-database data; as well as … Continue reading

Posted in Report | Leave a comment

The Three Stages in Building Reports with Heterogeneous Data Sources

There are many different types of report data sources, including relational databases, NoSQL databases, local files, HDFS files and JSON data stream. It’s easy to build a report with a single data source, but it’s difficult to build one that … Continue reading

Posted in Report | Leave a comment

esProc Assists BIRT in Handling Irregular Month Grouping

Problem source: http://developer.actuate.com/community/forum/index.php?/topic/36323-months-and-quarters-group-issue/ Irregular month grouping: If the start date is 2014-01-10, group dates from this date to 2014-02-09 together and dates from 2014-02-10 to 2014-03-9 together. If the start date is 2014-01-31, put dates from this date to 2014-02-27 into … Continue reading

Posted in Report | Tagged , , , | Leave a comment

Calculate Growth Rate in Jasper Crosstabs

Problem source: http://community.jaspersoft.com/questions/847490/how-get-annual-growth-rate-crosstab . As every column in a crosstab is generated dynamically, you also need to reference them dynamically when performing inter-row calculations. There is some difficulty in handling this dynamic reference using a Jasper script. But the data … Continue reading

Posted in Report | Tagged , , | Leave a comment

esProc Assists Jasper in Calculating Loan Payments

Problem source: http://community.jaspersoft.com/questions/851148/loop-jasper The calculation of loan payments according to loan amount will involve loop operation and inter-row operation. It is difficult to write code for it using stored procedure or Scriptlets. Yet with the help of esProc, the Jasper … Continue reading

Posted in Report | Tagged , , , | Leave a comment

esProc Assists Jasper in Calculating Opening Balance

Problem source: http://community.jaspersoft.com/questions/850400/how-create-report-opening-balance-using-jasper-reports . The calculation of opening balances according to deposit and withdraw amount involves inter-row operation. Jasper can do the calculation but the code is complicated. You can use esProc to assist the job and make it easy. The following … Continue reading

Posted in Report | Tagged , , , | Leave a comment

esProc Assists BIRT in Splitting Fields and Converting Them to Records

Problem source: http://developer.actuate.com/community/forum/index.php?/topic/36204-split-data-row/ To split fields apart and recombine them into records, you can use the stored procedure or a report script. But as the code is complex, an alternative choice is using esProc to help the reporting tool with … Continue reading

Posted in Report | Tagged , , , | Leave a comment