Search

[code] <script type="text/javascript" charset="utf-8" src="media/js/jquery.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/jquery.dataTables.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/TableTools.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/ZeroClipboard.js"></script> <script type="text/javascript" charset="utf-8"> $(document).ready( function () { TableTools.DEFAULTS.aButtons = [ "print","pdf", "xls" ]; $('#example').dataTable( { "bRetrieve": true, "sDom" : 'T<"clear">lfrtip' /*"oTableTools": { "aButtons": ["print","pdf", "xls"] }*/ } ); } ); </script> [/code]

DataTables isn't designed to work with tables like that at all. So while you could add the classes needed to get the right colouring, the sorting, filtering and paging certainly won't work I'm afraid. Sorry - DataTables just wasn't designed for that. Allan

Thanks for the reply allan. Unfortunately that didnt work for me :( . But it seems like that i have the problem even tough it is only numeric data i got in the column. So maybe it is a general error? Maybe you can make a plugin that excludes which in my brackets "()" and then only account for raw data for something..

ok I figured. I just wanted to make sure there wasn't a "correct" way of doing it first. Thanks :)

The two columns example isn't actually released yet - sorry for the dead link :-(. You can grab the latest source which will work with the two tables example from Github: https://github.com/DataTables/ColVis . However, it doesn't sound like it is exactly what you need - that will just show two tables with two different boxes for ColVis (one for each column). What it sounds like you need is http://datatables.net/api#fnSetColumnVis which allows a custom implementation of column visibility and you can control the visibility of multiple columns from a single control (if you set it up that way). Allan

I've seen this happen with IE8 when it is in compatibility mode. Check to see if IE is running in compatibility mode, and if it is, switch out of that mode.

It certainly is: http://datatables.net/extras/tabletools/button_options#mColumns :-) Allan

If you are using DataTales 1.7.3 (possibly 1.7.2 - can't quite remember....) you can do something like this: [code] table.display thead th div.DataTables_sort_wrapper { position: relative; padding-right: 20px; padding-right: 20px; } table.display thead th div.DataTables_sort_wrapper span { position: absolute; top: 50%; margin-top: -8px; right: 0; } [/code] Allan

Not come across this one before - can you post a link to an example showing this issue please? Allan

I once started down the road of attempting to send data back to the server to create an Excel spreadsheet, but then the requirements of the project changed so I didn't actually get very far with it. I was using fnGetFileredData and then looping through the results to build up the data in JSON structure. I'm pretty awful at JavaScript myself so I'd like to see some other solutions, but here is a function from my notes that was working as far as it goes... [code] < script type="text/javascript"> $(document).ready( function() { $('#classSummary').click( function () { var myTable=new Array(); var myJSON; myJSON = '{"bindings": ['; var aNodes = oTable.fnGetFilteredData(); for ( var i=0, iLen=aNodes.length ; i<iLen; i++) { myJSON = myJSON + '{"Name":"' + aNodes[i][0] + '",'; myJSON = myJSON + '"FullName":"' + aNodes[i][1] + '",'; myJSON = myJSON + '"AskAmount":"' + aNodes[i][2] + '",'; }; myJSON = myJSON + "]};"; }); }); [/code] On the server, I was going to use perl modules to parse the JSON and create the Excel file. Probably these: http://search.cpan.org/~makamaka/JSON-2.22/lib/JSON.pm http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/