Search

Thanks!

actually sorted this out - i had a little bit of a mess with hidden columns and jquery updates. sorry for the inconvenience! wonderful work

It is quite a common thing, and it's in the FAQs: http://datatables.net/faqs#ss_events :-) . I'd suggest just using a live event rather than $().click() for this, since it will be much easier to maintain. Allan

[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