Report Results Split between pages

[TonyCh1]

Can anyone explain the logic behind how Workfront divides what shows up on reports?  Here's my situation. I have a report and it has 2428 projects on it.  Some are the status of "in progress" and some are "Closed".  The limit on the number of items to view is 2000.  When I look at the report I thought I would see in the 1 - 2000 all my in progress then all my closed.  Then in 2001 - 2428 I would see the remainder of the projects.  What I am seeing is part of my in progress and part of my closed in 1 - 2000 then in 2001 - 2428 I am seeing more of In Progress and more of Closed.

[KellieGardner]

The default sorting in Workfront has always baffled me. It doesn't appear to follow any logic that I've notcied and I've never seen documentation on what the default sorting is.

You can however, set your reports to default by a specific column you want such as status.

[TonyCh1]

We do have it grouped by status first and then by department second.  I'm trying to understand why won't just show the one status together on the page and then put the other status on the second page by iteself.