Discussions

Expand all | Collapse all

How to disable the total field in the summary report

  • 1.  How to disable the total field in the summary report

    Posted 09-11-2019 09:42
    Hi Everyone,

    Can some one please help me to disable the total column that comes as default in the summary report.

    Though i Checked the two "hide" total boxes in the summary report page. I still see the totals to the right for the columns i have.

    Please help. Thanks in advance

    ------------------------------
    Pushpakumar Gnanadurai
    ------------------------------


  • 2.  RE: How to disable the total field in the summary report

    Posted 09-11-2019 10:08
    The bottom totals can be disabled but not the right hand side totals.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------



  • 3.  RE: How to disable the total field in the summary report

    Posted 23 days ago
    I have a report with several columns of numeric data and I think it's great that it automatically adds them up for the total row; however, one of the columns is for percentages and rather than have that added up for each row, I would like that column's total to be an average or just not there. It reads funny to have some things over 100% because that would be impossible for what we are calculating.

    ------------------------------
    Steve Hanson
    ------------------------------



  • 4.  RE: How to disable the total field in the summary report

    Posted 09-11-2019 11:39
    I use script to hide those on summary reports

    Hide columns


    //hide 3rd column on report
    $("#tableid td:nth-child(3)").hide();
    ​
    //hide bottom row
    $(".totals").hide();
    #tableid - HTML table id, usually VR_dbid_reportid
    td:nth-child(3) - should be the last column number



    ------------------------------
    Everett Patterson
    ------------------------------



  • 5.  RE: How to disable the total field in the summary report

    Posted 09-12-2019 01:24
    Hi Everett,

    Could you please kindly let me know the procedure to use the above script. 

    Can you please give step by step information. 

    Thanks a lot in advance.


    ------------------------------
    Pushpakumar Gnanadurai
    ------------------------------



  • 6.  RE: How to disable the total field in the summary report

    Posted 23 days ago
    Everett,

    I am curious how you deployed the script.  Is this IOL?  Some other technique?

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 7.  RE: How to disable the total field in the summary report

    Posted 23 days ago
    There should be multiple ways to do it. IOL is nice because it works for pretty much everyone and they don't need to install anything or even know it is happening. You could also do it via something like TamperMonkey, I have some personal scripts that run on certain pages that make QuickBase a better user experience for me or add additional functionality.


  • 8.  RE: How to disable the total field in the summary report

    Posted 23 days ago
    Hi Pushpakumar,

    Mark is correct that the right hand side totals don't have a way to be disabled like the overall totals do. If being able to do this would be helpful for your use of summary tables and reporting I would suggest submitting that as feedback to our User Voice. User Voice is a tool our product development team uses to track user interest in new features and enhancements to existing features. The Quick Base User voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab that appears on the right of the page or at http://quickbase.uservoice.com by signing in with your Quick Base credentials. If you do put this request in I definitely recommend linking back to it here so that other community members with the same need can add their vote.

    I'll also throw out our standard warning that when using methods like IOL and script to change things in Quick Base those methods aren't supported by us and as such they can break or cause unintended changes when we do updates to the product. So any use of IOL and other methods are at your own discretion and behavior is subject to change.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------



  • 9.  RE: How to disable the total field in the summary report

    Posted 22 days ago
    Hi Evan,

    Thanks a lot for the suggestion. I tried logging in  http://quickbase.uservoice.com but unfortunately cant do. There is something worng with SAML authentication.

    can you please post this on my behalf?

    Thanks
    Pushpakumar 


    ------------------------------
    Pushpakumar Gnanadurai
    ------------------------------