report totals not showing in Excel when saving as spreadsheet
When you save a report as a spreadsheet the totals on the report are not saved in excel? Why is that? Is there a way to get the totals on the report into Excel?
You can do this with script. Here is a five minute effort achieved by manually pasting a short script into the console and loading the resulting file into OpenOffice's Calc (or Excel)
Script:
var content = $('<div>').append($("table.searchResults").clone()).html(); var filename = "myfile.html" function download(filename, content) { var blob = new Blob([content]); var a = document.createElement("a"); a.href = window.URL.createObjectURL(blob); a.download = filename; a.style.display = "none"; document.body.appendChild(a); a.click(); } download(filename, content);
In general you can download anything your want in any format you want using script and you can get an fancy or as automated as you want.
I did this from the console because as it is the fastest way to produce the result. However, it is a simple matter to integrate the script into a workflow that melds seamlessly with the GUI.
My advice is to embrace the script into your life and forgo the pain and suffering of waiting four years for a feature that may or may not show up.
Hi! Any update on this becoming a built-in feature in the last 4 years? Automatically showing totals within the exported Summary Report would be ideal.