This one is a little complicated to answer since it looks like you have recently switched from the Legacy database to the Cloud database.
In the Legacy database, you can set the status for a person (and reset it during NYS). That information is stored as a part of the person's record, thus the status only reflects what it is at any given moment. It doesn't store that information historically. The grade is handled the same way.
This works differently in the Cloud database. A person's status is determined by the status of all roles in the current club year; but a status for each role (in each year) is stored. That may sound confusing, but it means better historical information. You can see that someone had an active role one, or two, or three years ago, even if the person's status is currently inactive (or archived or anything else). The Cloud database also stores the grade with the role for each year for a better historical picture.
Unfortunately, the reports are not designed to handle this historical information yet as they are based on the same reports from the Legacy database. We will eventually make changes to better access this historical data we now track.
The Windows App will show previous year role information on the Member record's Roles tab. Each year's role record tracks a status and grade. (Since grades weren't tracked historically in the Legacy database, any migrated data will not have the historical grade information. We were able to determine a status for most historical roles based on the session/attendance records.) We do intend to add a Main Tab for analyzing Roles (like the Main Tabs for Clubbers and Leaders) which would provide options for gathering information like you want. We are heading in that direction, but not quite there yet!
Next year, you will be able to see the role status and grade from this club year as historical data. We hope by then you'll also have improved tools to take advantage of that information!