ReportTDK for Jsp ~ Tran Dang Khoa

ReportTDK for jsp allows to create report excel from template excel with a few lines of code.

Features:

Support parts: Detail, Group, Group Footer, Total
Support style, format for cell
Support formulas in Detail ( such as:=C5*D5), Group,Total ( such as: =SUMIF(J$7,"1",I$7), I is column to get SUM, J is column to compare to 1, 7 id row of Detail)
Allow to set protectec password for report to anti edit

Demos:

Customer Demo: Detail, Col To Merge, Order Col, Param
Customer With Many Sheet Demo: Detail, Col To Merge, Order Col, Param, Sheet Paging with param 'Max Row' in template
Invoice Demo: Detail, Total, Formula, Col To Merge, Order Col, Param
Invoice Detail Demo: Group, Detail, Total, Col To Merge, Order Col, Param
Invoice Detail With Dynamic Column Demo: Group, Detail, Total, Col To Merge, Order Col, Param, Dynamic Column ( allow to add new columns in code)
Invoice Detail With Dynamic Group Demo: Group, Detail, Total, Col To Merge, Order Col, Param, Dynamic Group (allow to remove group in code)
Invoice Detail With Group Footer Demo: Group, Group Footer, Detail, Total, Col To Merge, Order Col, Param
Multi ResultSet Multi Sheet Demo: allows many sub reports with Group or Total in many sheet

Code Demo:

$report= new Reportx($vtRS, $strTemplatePath, $strReportPath);

$strReportDate = date('d/m/y');
$report->setParameter('$ReportDate', $strReportDate);

$report->fillDataToExcel(false);

$report->unInit();

Contact:

Tran Dang Khoa