Grouping on Reports and Show All Records

[jmiskey]

In creating reports in ServiceNow, you can Group records by a field of your choice.  We use this functionality, and have come across something odd, which we cannot seem to find the solution to.  If any one "Group" has more records than your list view setting of records per page, their does not seem to be an option to see the other records (without going to some list, and changing your list to show more records per page).  We were expecting to see some sort of "Next" arrow or record selector, but none is present.

For example, we have a report that returns three Groups.  The first has 1 record, the second has 30 records, and the third has 6 records.  The user has his list set to display 20 records per page.  So what ServiceNow shows is the record from Group 1, the first 20 records from Group 2, and all 6 records from Group 3.  We cannot get it to display the last 10 records from Group 1 (without changing settings to show 50 or 100 records per page).

Is there some tricky to be able to view these other records, aside from changing the number of records to return per page (which would only work if there were less than 100 records in a Group anyway)?  We know that we can export them, and all will be exported, but want to know if there is a way to view them all without exporting.

Thanks

[Coleton · Accepted solution]

You're telling the system to limit the record view per page so that's what the record limit will look like. The user can click the group name next to the arrow to expand the grouping, and it will take you to that list of records specifically. There's no way to next page in a grouped list.

Hope this answers your question, sorry there's no trick. 😞

[jmiskey]

That was what we were missing!  We can click on the Group Header, and get the full listing, and can then access any records that are beyond the first page.  Don't know why we didn't think to try clicking that Group Header...

Thank you!

[sukawork]

What if you want to stay in on the page, then you will not be able to 'go to next page' eventhough the list is more more than 200 records which is at least 2 pages.

Can anyon confirm that's how it is ? 

[Coleton]

Well, the idea is that you don't want to load a large number of records on one page. The additional records in a list view = longer load times which creates a bad UX. If I know that I want to look at a list for all records assigned to a group, I'm okay with the list view showing 25-50 records a page, regardless of the record count they might have.

Hope this answers what you were asking about. If not, please elaborate a bit more on your initial question. Thanks.