Show Aggregation rows dynamically

[Gillian]

Hi

Is there a way to show/hide the Subtotals and or Grand Totals on a grouped Report DataPage.  I don't want to show the Subtotals if there is only one row in the group.

[Aether]

Hi @Gillian - You can try the suggested solution here, similar to your needs. You can just alter the code:

 

[Aether]

Here is a sample code you can use:

<SCRIPT LANGUAGE="JavaScript">
var elems = 
document.getElementsByClassName("cbResultSetGroup1Label cbResultSetGroup1LabelCellNumberDate");
for (var i=0, m=elems.length; i<m; i++) {
if (elems[i].innerHTML=="1") { elems[i].innerHTML=null;}
}
</SCRIPT>

On my sample, I have an aggregation that counts the number of records under it so that I can hide the subtotal with "1". Here is the sample output:

[Aether]

The other way around this is to use custom formula on your aggregation to only total if the count of the record is not "1".

Here is the sample formula:

CASE WHEN ((COUNT([@field:ID]))<>1)
THEN (COUNT([@field:ID]))
END