FixedColumn not working with server side processing in dataTables..??

FixedColumn not working with server side processing in dataTables..??

kavittpkavittp Posts: 12Questions: 0Answers: 0
edited July 2013 in DataTables 1.9
Dear Allan..,

I am facing some critical problem in dataTables.
Right now i am using dataTable with serverside processing.
Actually my table contains large no. of columns...so i just want to implement FixedColumn with server side processing.

So according to dataTable's documentation i used FixedColumn and initialized it in dataTable.

As a result..when dataTable implements..it doesn't follow FixedColumn property.. and dataTables columns cross the limit of div container.
i means to say..my dataTables is crossing the outer div container's border.

and it also showing me a error like:
"Object doesn't support this property or method"
"jquery.dataTables.js Line :3709"

Please help me to sort out this problem...Its very urgent for me.
i just to draw my datatable inside div container not outside it.

I am sending my code ..may be i have done something wrong there...please check it to solve my problem..
Thanks in advance...

Java Script Code :
[code]

oTable = $("#ft").dataTable({
"bDestroy":true,
"bRetrieve": false,
"bJQueryUI": true,
"bServerSide": true,
"bAutoWidth": false,
"sScrollX": "100%",
"sAjaxSource": "/web_trial_one/DatasourceGsonServlet?button_name="+button_id+"&txt_mtr_from="+str_from_mtr+"&txt_mtr_to="+str_to_mtr,
"bProcessing": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear">lfrtip', //'<"H"Tfr>t<"F"ip>' to print tabletool in UI theme within border.
"oTableTools": {
"aButtons": [ "copy","csv","xls","pdf",
{
"sExtends": "download",
"sButtonText": "Download Excel",
"sUrl": "/web_trial_one/FTDownload?txt_mtr_from="+str_from_mtr+"&txt_mtr_to="+str_to_mtr+"&txt_cca_from="+str_from_cca+"&txt_cca_to="+str_to_cca+"&txt_catcode="+str_catcode+"&txt_assemb="+str_assemb+"&txt_clem="+str_clem+"&txt_tariff="+str_tariff+"&txt_mask_id="+str_mask+"&txt_site="+str_site+"&txt_cca_test_from="+str_cca_test_from+"&txt_cca_test_to="+str_cca_test_to+"&txt_ft_test_from="+str_ft_test_from+"&txt_ft_test_to="+str_ft_test_to
}

],
"sSwfPath": "./table_tool2.0/media/swf/copy_cvs_xls_pdf.swf"
},

"fnInitComplete": function() {
new FixedColumns( oTable, {
"iLeftColumns": 5,
"iLeftWidth": 420

} );
}


});


[/code]


HTML Code :

[code]






CCA No.
Test Date
Meter Serial No.
Stage
SO Number
Product Code
Meter Test Status
Tested By
Site Name
Test Name
test Value
Test Code Status
Batch No.





Loading Data From Server...









[/code]

Replies

  • allanallan Posts: 63,383Questions: 1Answers: 10,449 Site admin
    Please link to a test case showing the issue. The two should work together okay.

    Allan
  • kavittpkavittp Posts: 12Questions: 0Answers: 0
    Dear Allan..,
    There are some of few issues related to above post..which i am facing right now ..sorry i skipped to write in above post...The issues are as following :

    1. When i used FixedColumn with server side processing( like above code)..at that time horizontal scroll bar is not appearing...While if i used Client side processing then it works fine and "sScrollx" feature is also working.

    2. This one is most unusal like.. When dataTable populates beyond the div container, Its showing two tags...you can see it in attached image..still i am not getting that how its possible..??

    3. When dataTable (from above code) populates..its showing me an error like:
    [code]
    "Object doesn't support this property or method"
    jquery.dataTables.js Line: 3709
    [/code]

    To show all above issues.. I've added a screenshot here: http://i.imgur.com/1iptQx4.png

    You can check in above attached link that my dataTable is expanding and going beyond the div Border (Black color)..

    Please..Please help me to sort out these problem...its very important for my existing application..

    and Sorry @allan ..i am not able to send a link for test case..Because if i send the above code in link as test case...it would also require data that should be populate in dataTable..and without those data you will not able to check the proper output of test case..so i think its not possible to send test case.

    So please sort out my problem through post and above above attached screenshot..

    i just want to use FixedColumn property with server side processing..

    Thanks in advance..

    I am waiting for your reply..
  • allanallan Posts: 63,383Questions: 1Answers: 10,449 Site admin
    I'm sorry - without a test case I don't know what is causing the issue nor why it would happen. I've just tried server-side processing with FixedColumn and it works fine for me: http://live.datatables.net/ezipeq/2/edit

    Allan
This discussion has been closed.