HTML I want to export the below two dataTables into a single pdf with single export button. Both the dataTables have different columns so it cannot be merged.
<div class="container" id="exTable">
<div class=" mt-3">
<h2>Basic Table Example1</h2>
<table class="table" id="example1" style="width:100%">
<thead class="table-dark">
<tr>
<th>User Priority</th>
<th>Average MTTR(Hrs)</th>
<th>Total Number Of Tickets</th>
</tr>
</thead>
<tbody>
<tr>
<td>1-Critical</td>
<td>164.12</td>
<td>182</td>
</tr>
<tr>
<td>2-High</td>
<td>190.23</td>
<td>498</td>
</tr>
<tr>
<td>3-Moderate</td>
<td>908.93</td>
<td>1511</td>
</tr>
<tr>
<td>4-Low</td>
<td>211.43</td>
<td>1817</td>
</tr>
</tbody>
</table>
</div>
<div class="table-responsive mt-3">
<h2>Basic Table Example2</h2>
<table class="table display nowrap" id="example2">
<thead class="table-dark">
<tr>
<th>Tower</th>
<th>CC</th>
<th>Cluster</th>
<th>Assignment Group</th>
<th>Ticket Priority</th>
<th>Average MTTR(Hrs)</th>
<th>Total Number Of Tickets</th>
<th>Incidents resolved Using KO's</th>
</tr>
</thead>
<tbody>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
<tr>
<td>MANUFACTURING</td>
<td>RICHMOND GROUPS</td>
<td>Workbrain - Infor HCM Version 6.1.2 - Enterprise Workforce Management</td>
<td>SN PM USA Workbrain WFM and ETM</td>
<td>1 - Critical</td>
<td>4.89</td>
<td>5</td>
<td>0</td>
</tr>
</tbody>
</table>
</div>
</div>
CSS
table{
table-layout:fixed;
}
td,th{
font-size:10px;overflow:hidden;
}
Java Script I want make changes in this dataTable jQuery functions in such a way that if I click on single button both the dataTables data should be exported in same pdf file.
$(document).ready(function () {
$('#example1').DataTable({
dom: 'Bfrtip',
buttons: [
'pdfHtml5'
]
});
});
$(document).ready(function () {
$('#example2').DataTable({
scrollX: true,
pageLength : 5,
lengthMenu: [[5, 10, 20, -1], [5, 10, 20, 'Todos']],
dom: 'Bfrtip',
buttons: [
'pdfHtml5'
]
});
});