List type reports using the Group by feature only display 20 records when uncollapsing

[Daniel Falarde1]

Hello,

a user made me realise that, when we build a list report, and then using the group by feature, if you uncollapse a group of items that has more than 20, it still only displays 20 records and you cannot page through them.

Is this a normal system behaviour ?

Has anyone noticed this ?

How can we work around this?

Looking forward to some guidance on this.

Daniel.

[Ankur Bawiskar]

Hi,

Users can scroll to the next page from the arrow.

Also rows per page is based on user preference

Regards
Ankur

[Daniel Falarde1]

the arrow is greyed out so it is not possible to scroll to the next page

where is user preference do you see this Ankur ?

[Ankur Bawiskar]

Hi,

please share screenshot

Regards
Ankur

[Adam Stout · Accepted solution]

This is normal and expected.  The list in each group is limited to the number of records the viewer has set to view for every list view.  The default is 20 but this is a user preference:

Group by in a large list with lots of distinct value can be a performance issue by itself, but without this limit, you could end up pulling pack an essentially unlimited number of rows on a single page.

If I need to see all the records, I right-click on the grouped header to open that full, pageable, list in a new tab.