Search

Thank you Kevin and Allan. Tooltips was the problem. Have excluded based on DTSB classes and working fine. Cheers Keith

There is a search event you can use. Kevin

I'm afraid I'm no expert in hosting web applications on window - however, I'm certain they will have server logs somewhere. Finding out where that 400 error is coming from is key! Allan

Nevermind. Figured it out here: https://datatables.net/forums/discussion/71307/excel-export-error I changed this file: https://github.com/DataTables/Buttons/blob/f70c766dab0566279e0189cccb48e05039997174/js/buttons.html5.js#L786 line 786 to: { match: /^[\d]{4}-[01][\d]-([0-9]|[1-2][0-9]|3[0-1])$/, style: 67, fmt: function (d) {return Math.round(25569 + (Date.parse(d) / (86400 * 1000)));}}

You could do this for example: <script> $(document).ready(function () { $('#table_id').DataTable({ dom: 'Brtip', buttons: [ 'copy', 'csv', { extend: "excel", title: function () { return "yourTitle" }, messageBottom: function () { return "yourMessageAtTheBottom" } }] }); }); </script> Here is another example also including messageTop. https://datatables.net/extensions/buttons/examples/html5/titleMessage.html

@allan Considering I am far from an experienced developer, I need things laid out like for a kid lol step 1, do this, step 2 put here etc.. after I pasted from documentation it kept throwing errors & I had to work through that. In the docs, the semi colons will toss errors. I am sure it is just my lack of experience

Since you are defining separate HTTP methods for each operation I suspect you will need to move the ajax.data option inside each HTTP method along with url and type. Kevin

if I modify an input which is associated with a field in the table below it must not send anything to the server. I guess that would be under your control. In the event handler you will need to check to see if the ajax.reload() should be used thus sending the filter data to the server. Kevin

The first step is to follow the troubleshooting steps provided at the link in the error: https://datatables.net/manual/tech-notes/7 The problem is likely an error caused in your server script. You will need to look at the server logs to determine why the response has an error. Kevin

Have you followed the steps in the technical notes linked to in the error? That'll be the place to start, Colin