A sample web application using CollinsReport.js (not released) to create PDF and HTML reports

WARNING: this is live, with 41,687 records in the T001_sample table

sql statement
Select top 400 * from t001_sample where Sample_POP_1990 > |population| order by sample_state,sample_city

Properties   report.sql report.rs report.row report.table report.header report.footer report.detailSelectUsing report.details.length report.details[i].table report.details[i].row report.details[i].columns.length report.details[i].columns[j].value report.details[i].columns[j].header report.details[i].columns[j].footer report.functions.length report.functions[i].name report.functions[i].value report.groups.length report.groups[i].header report.groups[i].footer report.page.header report.page.footer report.parameters.length report.parameters[i].name report.parameters[i].value Methods   report.findDetail(value) report.findFunction(name) report.findParameter(name) value = report.sqlValue(sql); rs = report.sqlRead(sql); Values   v.populationTotal v.populationGrandTotal

Run Script Before: Report Page Table Group Detail

Properties   report.sql report.rs report.row report.table report.header report.footer report.detailSelectUsing report.details.length report.details[i].table report.details[i].row report.details[i].columns.length report.details[i].columns[j].value report.details[i].columns[j].header report.details[i].columns[j].footer report.functions.length report.functions[i].name report.functions[i].value report.groups.length report.groups[i].header report.groups[i].footer report.page.header report.page.footer report.parameters.length report.parameters[i].name report.parameters[i].value Methods   report.findDetail(value) report.findFunction(name) report.findParameter(name) value = report.sqlValue(sql); rs = report.sqlRead(sql); Values   v.populationTotal v.populationGrandTotal    v.populationGrandTotal = 0;