Fixed Column data does not change as the page changes

qamar

Hi,

I have a requirement to fixed 4 most left side columns, this columns should not be scroll-able, rest of them should be. I have added the fixed column settings and its locks the 4 leftmost columns, but as I click on next page these 4 columns data don't change only data which is scrollable is changing. Is it the normal behaviour or I am missing something. Here is my setup:


var oTable = $('#tblStudents').dataTable({
"oLanguage": { "sSearch": "Search the students:" },
"iDisplayLength": 10,
"sScrollX": "101%",
"aaSorting": [[0, "asc"]],
"sPaginationType": "full_numbers",
"bJQueryUI": true,
"sDom": '<"H"Tfr>t<"F"ip>',
"oTableTools": {
"sSwfPath": "TableTools-2.1.3/media/swf/copy_csv_xls_pdf.swf",
"aButtons": [
"copy",
"csv",
"xls",
{
"sExtends": "pdf",
"sTitle": "Search Students",
"sPdfOrientation": "landscape",
"sPdfMessage": "Student reports"
},
"print"
]
}
});
new FixedColumns(oTable, {
"iLeftColumns": 4,
"iLeftWidth": 350
});

I also have first two rows inside the table as generic table header which I don't like to be included in the column lock. I don't want those two rows text added as locked header. How can I achieve this? Here are those rows:

Student Billing Report

allan

Link to a test please showing the problem please.

Allan

raja_gola

Yes, me too facing the same problem.
my config.

var oTable = $('#hardware1').dataTable({
'sScrollX': '150%',
'sScrollY': '300px',
'bScrollCollapse':true,
'bPaginate':true,
'sPaginationType': 'bootstrap'
});
new FixedColumns(oTable, { 'iLeftColumns':1});

allan

As before, please link to a test case.

Allan