If you still want the result to be exportable, adjustable according to serach etc, then as long as you can determine te sql its using you can even render it yourself, so for this example am going to reproduce a similar output from demo project so maybe it will give you a new insight.
NOTE: am using demo project supplier table for this.
comparing the two outputs the the bottom one if more complicated so i will let it be whats fendered by default ie use list template for it
########draw the detail complete(one below##########
- we use php list template to render the bottom summary where each record presented as
filed1
filed2
filed3
Go to custom template->table specific->list page->custom template body and put code
<table class="table table-bordered">
<tr><td>{{{CompanyName}}}<td></tr>
<tr><td>{{{ContactName}}}<td></tr>
<tr><td>{{{ContactTitle}}}<td></tr>
<table>
########draw the detail complete(one below##########
########draw te summary table(one below##########
Assumming you want to draw it at te top.
-we get the sql that the list page is going to use to select from te database
-we gte the current pagination setting to know how many it is going to render
-we add the limit and offset to select the same result it is displaying
-we adjust te select to only pick desired fields.
-we render result in a table and add it to the eader of te page(beofre the list)
Go to list page->page_data_rendering and put
// Page Data Rendering event
function Page_DataRendering(&$header) {
// Example:
//$header = "your header";
//get the sql it uses to render the current list
$list_sql = $this->ListSQL();
var_dump($list_sql);
//get the pagination
$DisplayRecs = $this->DisplayRecs;
$StartRec = $this->StartRec;
$RecRange = $this->RecRange;
//formulate sql offset
$sql_offset = $StartRec - 1;
//add limiters on sql
$list_sql .= " LIMIT $DisplayRecs OFFSET $sql_offset ";
//edit sql to only pick one field
//replace * with filed name
$list_sql = str_ireplace("*","CompanyName",$list_sql);
var_dump($list_sql);
$header = '<div class="panel panel-default">
<div class="panel-heading">summary of returned records at top</div>'
.ew_ExecuteHtml($list_sql,array("fieldcaption" => TRUE))
.'</div>';
}
########draw te summary table(one below##########
HINT: you can even do it in page_data rendered it you want to draw it in footer. youcan even hide the default table and just use those two events to draw your own custom output that is still responds to pagination and serac filters.