Achieve checking multiple selections and batch deletions in row input report with RAQ Report

Background

For users of report, efficiency is very important. However, sometimes users have to do some simple operation time and again.

For example, there are a lot of data on a web page when making a row input report. Users may want to delete the data of 28 rows. If they have to click the “Delete” button every time when they delete a row, the page will be refreshed 28 times. That’s very inefficiency.

Then, how to solve it?

Solution

RAQ Report is a pure Web-based Java reporting tool. As it is a professional Web reporting tool, RAQ Report can help users to achieve batch selection and deletion in a row input easily.

Operation

With RAQ Report, you only need 4 steps.

Step 1: Design the report as shown below:

Note: A2 is set as checkbox. Set “Off” 0 and “On” 1.

Step 2: In the jsp file, add batch deletion javascript as follows:

function deleteRows(){
var report = document.getElementById('report1′);
for(var i=report.rows.length-2;i>0;i-){
var row = report.rows[i];
if(!row.all.tags("input")[0].checked) continue;
var cell = row.cells[1];
report.currCell = cell;
_deleteRow(report);
}
}

Step 3: In the jsp file, add checkbox javascript as follows:

function selcheck() {
var objs = report1.getElementsByTagName("input");
for(var i=0; i<objs.length; i++) {
if(objs[i].type.toLowerCase() == "checkbox" )
objs[i].checked =event.srcElement.checked;
}
}

Step 4: In the jsp file, add operating button javascript as follows:

<table>
<tr>
<td style="background-color:">
<div noWrap style="color:;">
Select all:<INPUT type="checkbox" onclick="selcheck()">
<span style="cursor:pointer" onclick="_insertRow( report1 )">Insert</span>
<span style="cursor:pointer" onclick="_appendRow( report1 )">Add</span>
<span style="cursor:pointer" onclick="deleteRows()">Delete</span>
<span style="cursor:pointer" onclick="_submitRowInput( report1 )">Submit</span>
</div>
</td>
</tr>
</table>

Graphic Illustration

Source: Knowledge Base of RAQ Report
Original Post: Achieve checking multiple selections and batch deletions in row input report with RAQ Report
Related Articles:
Dynamically add or delete a row when inputting data;
Make drop-down box for multiple choices with reporting tool;
Dynamic Row & Automatic Computation for Input Report;
Wonderful data input with reporting tool;
Useful Links:
Knowledge Base of Java Reporting Tool;
Jackson’s Reporting Review;
BIRT Multi-Select Statements;
Reporting Insights from Raqman;

RAQSOFT: Innovative Techology Makes Progress.

For more about reporting tool, you are welcome to refer to freezea's blog.