Hello,
To achieve this, you can follow these steps:
Disable the Export Data Option:
If you’re using Power BI, you can disable the export data option for specific reports by going to the report settings and setting the “Export Data” option to "None".
For ASP.NET Core Report Viewer, you can hide the export options using the exportOptions property.
Create a Custom Download Button:
You can add a custom button to your report or web page that triggers the download of the table data. Here’s a basic example using Javascript:
<button id="downloadButton">Download Data</button>
<table id="dataTable">
<!-- Your table data here -->
</table>
<script>
document.getElementById('downloadButton').addEventListener('click', function() {
var table = document.getElementById('dataTable');
var rows = table.rows;
var csvContent = '';
for (var i = 0; i < rows.length; i++) {
var cells = rows[i].cells;
var rowContent = [];
for (var j = 0; j < cells.length; j++) {
rowContent.push(cells[j].innerText);
}
csvContent += rowContent.join(',') + '\n';
}
var blob = new Blob([csvContent], { type: 'text/csv' });
var url = window.URL.createObjectURL(blob);
var a = document.createElement('a');
a.setAttribute('href', url);
a.setAttribute('download', 'table_data.csv');
a.click();
});
</script>
This script will create a CSV file from the table data and download it when the button costcoess is clicked.
