Search

For Example: 12345 I want to display 12,345.00

I am running into a problem with displaying several hundred records (700 or so) at once on the page. I am using server side code to load the data, but my client is requiring all records to be displayed at once so that I can total some of the columns. The data is being returned in around 1s but it is taking datatables an additional 6s to render the data. This is border line on the edge of how long they want to wait to see the data and it only gets worse the more records there are. I have looked into the scroller plugin with the bDeferRender option, and like the way that behaves, except my total row, now only shows the visible records and not the whole data set. Is there any way with scroller to sum the whole data set?

Please read my question that I post on Stack overflow http://stackoverflow.com/questions/18420093/datatables-jquery-header-and-footer-alignment Advance Thanks!

using fnFooterCallback... I understand how to rip through ALL the rows of a table and sum columns... or.. rip through what is on the screen (page shown only). I need to know how to identify what rows are NOT shown because of a filter (using the search feature, for example) and skip those when totaling all rows ... regardless of what is on screen. (I want ALL rows that meet the search criteria - which is more than what pagenation shows you...) Any quick ideas?

Hello Guys, I have 2 datatables with ajax in one page, and repeat for me the sInfo. What I need do for dont repeat the sInfo ? Thanks !

Hi, Greetings to Datatables.. In my table i set one column visible false..but the beside column search doesnot work it searches the hidden column.. plz help me..

Hi All, Hi Allan, I'm currently having an issue with sScrollX and column alignment (possibly caused by multiple tables, but have not verified that yet). The website i'm busy designing is going to be used by a few clients and will be integrated into their sites using an iframe. (Don't ask me why an iframe, but thats what i've got to work with.) This means that all the functionality of my site will be found on one html page. This page will have multiple tabs (using jquery-ui stuffs) for the various different sections. That's all well and completely unrelated to the topic; the essence being that I am working with multiple tables as I have to load all my tables on the "same" page. I have one setting that i use for all these tables (as multiple tables share the setting, and don't have a setting per table). These settings are as such: [code] { "bPaginate": false, "bLengthChange": true, "bFilter": true, "bInfo": true, "bAutoWidth": true, "bDestroy": true, "bRetrieve": false, "bJQueryUI": true, "bProcessing": true, "sScrollX": "100%", "bScrollCollapse": true, "sPaginationType": "full_numbers", "bStateSave": false } [/code] When the tables that have too many columns, or data that forces the table to stretch past the width of the screen (adding a x-scroll bar), the headers don't align with the table's data columns. If i click on a header cell to sort the data, then the table seems to recalculate the widths, and all the columns are aligned. Is there a reference or function that fixes this, or will I need to write some code to force a "recalculation"? Thanks in advance, Gavin

No question about this now, there is a similar thread in http://datatables.net/forums/discussion/2170/excessive-bottom-padding-between-datatable-and-next-element/p1

hello, could you help me solve this problem? http://www.subirimagenes.com/imagen-capturadepantalla-7695201.html [code] listarreserva = $('.listarreserva').dataTable( { "bJQueryUI": true, "sScrollY": "450px", "bPaginate": false, "bScrollCollapse": true, "aoColumns": [ { sWidth: '10%' }, { sWidth: '20%' }, { sWidth: '10%' }, { sWidth: '10%' }, { sWidth: '5%' }, { sWidth: '10%'}, { sWidth: '35%'} ], "oLanguage": { "sProcessing": "Procesando...", "sLengthMenu": "Mostrar MENU registros", "sZeroRecords": "No se encontraron resultados", "sInfo": "Mostrando desde START hasta END de TOTAL registros", "sInfoEmpty": "No existen registros", "sInfoFiltered": "(filtrado de un total de MAX líneas)", "sInfoPostFix": "", "sSearch": "Buscar:", "sUrl": "", "oPaginate": { "sFirst": "Primero", "sPrevious": "Anterior", "sNext": "Siguiente", "sLast": "Último" } } } ) [/code] thanks

hello, could you help me solve this problem? http://www.subirimagenes.com/imagen-capturadepantalla-7695201.html code: listarreserva = $('.listarreserva').dataTable( { "bJQueryUI": true, "sScrollY": "450px", "bPaginate": false, "bScrollCollapse": true, "aoColumns": [ { sWidth: '10%' }, { sWidth: '20%' }, { sWidth: '10%' }, { sWidth: '10%' }, { sWidth: '5%' }, { sWidth: '10%'}, { sWidth: '35%'} ], "oLanguage": { "sProcessing": "Procesando...", "sLengthMenu": "Mostrar MENU registros", "sZeroRecords": "No se encontraron resultados", "sInfo": "Mostrando desde START hasta END de TOTAL registros", "sInfoEmpty": "No existen registros", "sInfoFiltered": "(filtrado de un total de MAX líneas)", "sInfoPostFix": "", "sSearch": "Buscar:", "sUrl": "", "oPaginate": { "sFirst": "Primero", "sPrevious": "Anterior", "sNext": "Siguiente", "sLast": "Último" } } } ) thanks