SWF is not exporting every column

mogli17

Hi,

I have been scratching my head to do this figure it out. When I click on SWF functionality to export .pdf, .xls or .csv, I only get one header export. Here is the code. In this case, it will export purpose,total,aib,which,others along with its data but it will NOT export the From To Date.

[code]


$(function() {
$('#mytable').dataTable( {
"sDom": 'T<"clear">lfrtip',
"sPaginationType": "full_numbers",
"aLengthMenu": [[25, 50, -1], [25, 50, "All"]],
"oTableTools": {
"aButtons": [
"copy",
"print",
{
"sExtends": "collection",
"sButtonText": "Save",
"aButtons": [ "csv", "xls", "pdf" ]
}
],

"sSwfPath": "/TC/assets/DataTables/TableTools/media/swf/copy_cvs_xls_pdf.swf",
}
});
});






From To Date



WORK
Total
AIB
WHICH
Others







<?php foreach ($rows as $r) :?>


<?php echo $r->WORK;?>


<?php echo $r->Total;?>


<?php echo $r->AIB;?>


<?php echo $r->WHICH;?>


<?php echo $r->Others;?>


<?php endforeach; ?>





[/code]

Please assist. Basically, when I export a report, i want to have a from and To date at the top of the report and then all the columns and rows after that.

Thanks in advance.