PDF export not showing all of table

colinod · November 2016

I have a large table with 52 columns and when i export to pdf it is only showing what is on the page and not doing more pages for more columns.

Also i have a header with two rows and it is not showing both rows

the page is hidden behind a login so cannot show on here but code for datatable is

$(document).ready(function() {
    $('#example').DataTable( {
         "lengthMenu": [[100, 250, 500, -1], [100, 250, 500, "All"]],
        dom: 'Blftip',
        select: true,
        "scrollY": 600,
        "scrollX": true,
        buttons: [
        
        {extend: 'excel',
        footer: 'true',
        text: 'Excel',
        title:'Statistics'  },
        
        {extend: 'pdf',
        footer: 'true',
        text: 'pdf',
        orientation: 'landscape',
        title:'Statistics'  },
        
        'print',
            
        {extend: 'excel',
        text: 'Selected Excel',
        footer: 'true',
        title:'Statistics',
        exportOptions: {
        modifier: {
        selected: true
                }
            }
        },
        {
        extend: 'pdf',
        footer: 'true',
        orientation: 'landscape',
        title:'Statistics',
        text: 'Selected PDF',
        exportOptions: {
        modifier: {
        selected: true
                        }
                    }
                }
        ]
    } );
} );

a8150242 · December 2016

yes,if the data processing server,datatables-buttons-pdf can`t export all of columns but export a page of data.

my solution:when you chick the button(pdf),start a new ajax to get all of data

after my test,the datatables-buttons-excel is working maybe the pdf is also working!

datatables.js:

var _exportData = function ( dt, inOpts )
{
    // fucking do something you want
    var config = $.extend( true, {}, {
        rows:           null,
        columns:        '',
        modifier:       {
            search: 'applied',
            order:  'applied'
        },
        orthogonal:     'display',
        stripHtml:      true,
        stripNewlines:  true,
        decodeEntities: true,
        trim:           true,
        format:         {
            header: function ( d ) {
                return strip( d );
            },
            footer: function ( d ) {
                return strip( d );
            },
            body: function ( d ) {
                return strip( d );
            }
        },
//add ajax start
        ajax: {
            async: false,
            dataType: 'json',
            url: '',
            data: dataMap,
            type: 'post'

        }
//add ajax end
    }, inOpts );

ps:happy to coding!!!

LiuWei

colinod · December 2016

I do not use json to call my data it is loaded into a table in the same page using classic asp.

will this matter as i am unsure how to use this

Thanks for your help

PDF export not showing all of table

PDF export not showing all of table

Answers

Howdy, Stranger!

Categories

DataTables

PDF export not showing all of table

PDF export not showing all of table

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables