Forum Discussion

AnonymousAnonym's avatar
AnonymousAnonym
Qrew Member
11 years ago

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?

Thank you

13 Replies

  • 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.

    Pastie Database
    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=699

    • ShelbyPons1's avatar
      ShelbyPons1
      Qrew Member
      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.

      ------------------------------
      Shelby Pons
      ------------------------------