Show group header above each displayed table

[Mahmood Ali]

Dear team,



I need your assistant and help in solving the issue while displaying the records in a table. I am looking for a group header to be placed above each printed table for its related category and subcategory, as well as, the no. of the records for each table to be shown at the top of the table.

The table contains columns for category, subcategory, name. ex:

Category Subcategory Name

CON Retail AAA

CON Wholesale BBB

SPEC Retail CCC



What I am looking for is the below layout:



Category/Subcategory (No. of records) –similar to a group header


Name – Country ..etc ----Table header

table records



Here is my code below:

<%
//Retrieve the values from the DB
while (rs.next())
{
category_name1=rs.getString("category_name");
subcategory_name1=rs.getString("subcategory_name");
//to compare the existing category with the previous one and to display group header
if ((category_name1).equals(temp_category_name) )
{
category_name1="";
%>
<%=category_name1%> / <%=subcategory_name1%> <%=count%> //Currently it is showing duplicate values many times and the count is wrong
<%
}
if (!(subcategory_name1).equals(temp_subcategory_name) )
{
count=0;
%>
<table width="80%">
<thead>
<tr>
<th>No.</th>
<th> Name</th>
<th>Country </th>
</tr>
</thead>
<%
}
%>
<tbody>
<%
name=rs.getString("name");
country_name=rs.getString("country_name");
temp_category_name=category_name1;
temp_subcategory_name=subcategory_name1;
count++;
%>
<tr>
<td><%=i%></td>
<td><%=institution_name%></td>
<td><%=country_name%></td>
</tr>
<%
}
%>
</tbody>
</table>

The problem in the above code is that it is showing the group headers category & sub ctageory multiple times and the count is incorrect. So, please assist me in correcting the above one.

[Bear Bibeault]

Why is there Java code in your JSP? This is a practice that has been obsolete for over 12 years.

[Mahmood Ali]

What do you suggest to overcome the issue? Or please provide me with some hints