Export to pdf,excel using Datatable grid for hierarchical data
Export to pdf,excel using Datatable grid for hierarchical data
I am using Jquery Datatable for plotting tabular information, alongwith i am using Datatable tools plugin which will be used for exporting to pdf,csv and excel.
In my scenario i have hierarchical information in my table the this information is appended on expand and collapse request by user.eg
when i click on + it send a $.ajax call and append a new nested table to the existing row eg
BillNo BillDate
- 1 14/03/2012
Item Qty Rate
chocolate 2 10
Similarly i have nested upto three level. when i export to pdf it neglect appended rows.
I have used independent export functions for inner and outer table but how can I can do that for both the tables together.
I want hierarchical data to be exported.