rowGrouping don't works properly
rowGrouping don't works properly
rlanhellas
Posts: 16Questions: 0Answers: 0
Well, i'm using the following code:
[code]
$('#rel_contato_pastores').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear"><"H"lfr>t<"F"ip>',
"oTableTools": {
"sSwfPath": "../../js/DataTables-1.9.4/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
"aButtons": [
{
"sExtends": "copy",
"sButtonText": "Copiar Tudo",
"sTitle": "ContatoPastores_WPAS",
"mColumns": [0, 1, 2, 3, 4, 5, 6, 7]
},
{
"sExtends": "xls",
"sButtonText": "Exportar para Excel",
"sTitle": "ContatoPastores_WPAS",
"mColumns": [0, 1, 2, 3, 4, 5, 6, 7]
},
{
"sExtends": "pdf",
"sButtonText": "Exportar para PDF",
"sTitle": "ContatoPastores_WPAS",
"mColumns": [0, 1, 2, 3, 4, 5, 6, 7]
}
]
},
"oLanguage": {
"sLengthMenu": "Mostrar _MENU_ registros por página",
"sZeroRecords": "Nenhum registro encontrado",
"sInfo": "Mostrando _START_ / _END_ de _TOTAL_ registro(s)",
"sInfoEmpty": "Mostrando 0 / 0 de 0 registros",
"sInfoFiltered": "(filtrado de _MAX_ registros)",
"sSearch": "Pesquisar: ",
"oPaginate": {
"sFirst": "Início",
"sPrevious": "Anterior",
"sNext": "Próximo",
"sLast": "Último"
}
},
"aaSorting": [[2, 'asc']],
"aoColumnDefs": [
{"sType": "num-html", "aTargets": [0]}
]
}).rowGrouping({iGroupingColumnIndex: 2,
sGroupBy: "letter",
bHideGroupingColumn: false});
[/code]
And in the DataTable only apper this simbol: ">" rather than a LETTER corresponding to the column.
[code]
$('#rel_contato_pastores').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear"><"H"lfr>t<"F"ip>',
"oTableTools": {
"sSwfPath": "../../js/DataTables-1.9.4/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
"aButtons": [
{
"sExtends": "copy",
"sButtonText": "Copiar Tudo",
"sTitle": "ContatoPastores_WPAS",
"mColumns": [0, 1, 2, 3, 4, 5, 6, 7]
},
{
"sExtends": "xls",
"sButtonText": "Exportar para Excel",
"sTitle": "ContatoPastores_WPAS",
"mColumns": [0, 1, 2, 3, 4, 5, 6, 7]
},
{
"sExtends": "pdf",
"sButtonText": "Exportar para PDF",
"sTitle": "ContatoPastores_WPAS",
"mColumns": [0, 1, 2, 3, 4, 5, 6, 7]
}
]
},
"oLanguage": {
"sLengthMenu": "Mostrar _MENU_ registros por página",
"sZeroRecords": "Nenhum registro encontrado",
"sInfo": "Mostrando _START_ / _END_ de _TOTAL_ registro(s)",
"sInfoEmpty": "Mostrando 0 / 0 de 0 registros",
"sInfoFiltered": "(filtrado de _MAX_ registros)",
"sSearch": "Pesquisar: ",
"oPaginate": {
"sFirst": "Início",
"sPrevious": "Anterior",
"sNext": "Próximo",
"sLast": "Último"
}
},
"aaSorting": [[2, 'asc']],
"aoColumnDefs": [
{"sType": "num-html", "aTargets": [0]}
]
}).rowGrouping({iGroupingColumnIndex: 2,
sGroupBy: "letter",
bHideGroupingColumn: false});
[/code]
And in the DataTable only apper this simbol: ">" rather than a LETTER corresponding to the column.
This discussion has been closed.
Replies
Well, the big problem is: When i export this with TableTools buttons to EXCEL or PDF the rowGrouping don't apper.