Monthly Archives: June 2015

esProc Assists Report Development – Different Datasources for Master Report and Subreport

Functionally, reporting tools like JasperReport or BIRT can handle the situation where the master report and the subreport(or the table) have their data sources in different databases. But data source names cannot be used directly in the subreport, instead they … Continue reading

Posted in Application, Reporting tool | Tagged , , , , | Leave a comment

esProc Assists Report Development – Crosstab In Which Row & Column Headers Are Intervals

It is difficult to deal with some unconventional statistical tasks using the reporting tool, like Jasper and BIRT, alone or SQL. One example is the crosstab in which both the row headers and column headers are intervals, and whose measurement … Continue reading

Posted in Application, Reporting tool | Tagged , , , , | Leave a comment

esProc Assists Report Development – Transpose Operation for Crosstab Creation

It’s difficult to handle unconventional statistical tasks using simply the reporting tool, like Jasper or BIRT, or SQL. One of the cases is that the source data don’t meet the crosstab’s requirements and thus need to be transposed for display. … Continue reading

Posted in Application, Reporting tool | Tagged , , , , | Leave a comment

esProc Assists Report Development – Create a Tabular Report by Transposition

Unconventional statistical tasks are difficult to be handled solely by the reporting tool like Jasper and BIRT, or the SQL. For example when the original data are not arranged as required by the tabular report, they need to be transposed … Continue reading

Posted in Application, Reporting tool | Tagged , , , | Leave a comment

esProc Assists Report Development – Irregular Cross Row Calculation

During data reporting there are many unconventional statistical tasks that are difficult to be handled solely by reporting tools, like Jasper and BIRT, or SQL. One case is to specify a particular record in the original data against which we … Continue reading

Posted in Application, Reporting tool | 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 … Continue reading

Posted in Application, Reporting tool | 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 … Continue reading

Posted in Application, Reporting tool | Tagged , , , | Leave a comment