Hide the records and Only display the aggregation

[thead]

Hi,

Is there a way to  hide the detail records? So it only displays the aggregation of a certain field.

[April]

Hi Thead,

Yes, you can hide the details and only display the aggregations. Please follow the below steps:

- Create a copy of the style you are using for your report page.
- Edit the Style, and then click "Source".
- Expand "Results Page" and click on "Table Layout"
- Go to the Source tab and add the following line in the .cbResultSetOddRow, .cbResultSetTableHeader" and .cbResultSetEvenRow class:

display:none;

- Update your report page and used the Style that you created.

Also to hide the pagination, under Results Page >> click paging  and then switch to source tab and find ".cbResultSetNavigationTable" to add display:none;

This will hide the record rows, table header and paging on your report.

Please see the below sample output:

Hope this helps.

[Flowers4Algernon]

Hello, this how-to link may also be helpful:

 

https://howto.caspio.com/styles/creating-or-editing-style/

[Lynda]

This solution also works for hiding to Totals on a Reports Page when you only want to see the Group Totals.

Sometimes the Grand Total doesn't make sense. It's the grouping totals that you want.

In the copy of your style sheet, under Aggregation, switch to Source. Locate cbResultSetTotalsLabelCell, cbResultSetTotalsLabel, cbResultSetTotalsDataCell, cbResultSetTotalsDataCellNumberDate, and cbResultSetTotalsData and add     display:none; to the attribute.

It works like a charm.

Thank you!

Lynda