Search

Can you change the response from the server to be: {"draw":1,"recordsTotal":57,"recordsFiltered":57,"data":[{"name":"Airi","position":"Satou","office":"Accountant","extn":"Tokyo","start_date":"28th Nov 08","salary":"$162,700"},{"name":"Airi","position":"Satou","office":"Accountant","extn":"Tokyo","start_date":"28th Nov 08","salary":"$162,700"}]} i.e. drop that outer data - that isn't part of DataTables expects. Allan

For server side processing, the protocol is discussed here. Also see examples here. I suspect your server isn't sending data back in the expected format. Cheers, Colin

ok, some code. You are not doing any customization of the excel export in that code. So this is not quite in line with "i want transpose rows and columns placement." Good luck!

Thanks a lot Mr. rf1234 and Mr. Allan

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here. Cheers, Colin

is this related to your other thread?

its okay now guys thank you, i just change the $sale->client_id to $client->id

Chicos @Hbra2310 y Jose, en efecto datatable no posee funcion propia para multiple headers, pero en Stackoverflow hay una funcion que te devuelve una matrix del Header, y lo que haces con esa matrix es trabajarla en funcion a lo que necesites (excluir o fusionar)

You can disable autoWidth, and set manually with columns.width. Colin

Thank you, I replaced it before doing JSON.parse().