Forum Discussion

Qrew Member

5 years ago

Suppressing report grand totals but not subtotals

I have a table report that calculates resource usage. The report is grouped on resource name, with detail records in each group that report information about each task assigned to the resource. One of...

reports and charts

Qrew Captain

5 years ago

Paul -

Unfortunately, this can't be done with the native report builder. You'll have to build a report from the ground up using JavaScript & HTML on a code page to display results from an API_DoQuery call.

------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------

Qrew Member

5 years ago

OK, thank you, you answered the question.

Much appreciated.
Paul

AustinK
Qrew Commander
5 years ago
Paul do you have Image On Load set up for your app? If you already have this then hiding the totals should be able to be done right there on the form. As Blake said it is not a native solution and requires JavaScript but you can definitely just do it on the form you view.

How comfortable are you with JavaScript? If not at all then this may not make any sense for you to explore. If you know something about it then you could consider doing this. Just know it is not supported by Quick Base and if their staff chime in they will reiterate that because it could stop working in the future.

The one part that can be tough is finding the table in the elements list. Once you do find the table the Totals part is its own element and can be hidden. I will not go into detail with this unless you want to explore doing it this way. I cannot give you the exact right code but I can guide you to find it.
- PaulStreit
  Qrew Member
  5 years ago
  Hi Austin,
  
  Unfortunately I'm not fluent in JavaScript. I'll figure out another path. I'm also not inclined to use a solution that QB won't support.
  
  Thank you though.
  
  Paul