With every management system you need good reporting tools and by reporting tools I mean tools which help you in creating beautiful and functional reports requiring minimal coding and very less user effort on the front end. Here is where JQueryDatatable comes in. If you need table functionality in your website and you do not want to write code for table functions like sorting, styling, searching , paging ,exporting etc. JQuery Datatables is your blessing in disguise.
Coming on to my project , I needed to generate custom reports according to user's needs from a master report containing everything . My approach was as follows : I extracted all the required data from my database , bind that data with a normal HTML table and then applied JQuery Datatable to it. With that I got the functionality to hide columns on specific events , sort table column wise automatically on header click ,add and remove rows dynamically and refresh the table with new source without reloading the whole page.