Skip to main content
Question

Suppressing report grand totals but not subtotals

  • October 6, 2020
  • 0 replies
  • 43 views

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 the fields calculates the percentage of a resource's capacity that has been allocated. This percentage can be summed across all tasks for the group because one group represents one resource. This works great. 

The problem is that the QB table report generator forces a report grand total, which is not accurate as the percentages are valid only for the subgroups (a summed percentage across all tasks and resources doesn't make any sense). I checked with Support and there's no way to suppress the grand totals while keeping the subtotals. It's all or nothing. 

Any ideas on how I can generate a grouped table report with subtotals but not grand totals?  

Thank you,
Paul

------------------------------
Paul Streit
------------------------------
This topic has been closed for replies.

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