Move record from one report to another
I wish to know how to move a record from one report to another? We have a Documents/Contracts form which contains a file upload field, a status, and a type. These documents update often so whenever we change the status to "Archive" we'd like the record to move to another report. I know we can set filters however we also have an "Account" form and report that we most often refer to. In the "All Accounts" report some entries have many documents/contracts and we wish not to have old expired documents filling up our Accounts report page.
Was thinking maybe adding a custom button for each record where I can click and the record will move from the Documents/Contracts report to the Archived report?
Any suggestions?
Thanks!