Sort and filter a list view dynamically
I've got a whole bunch of project records on a list view and each project has an assignment to a member of staff. In addition, it has a status, such as started, waiting on customer, on hold etc.
Given that in time there will be hundreds of these, and given that I'm not displaying them in a portal (because the layout I'm using is most closely linked to the table where the information is)...
How can I set sort and filter options on this report which respond to user inputs in the same way that normal ERP software would do?
For example, to sort by staff name, I'd like to click an A-Z icon.
To filter by staff name, I'd like to be able to select from a dropdown (or popup) and hit a Go button.
I've searched around for this and cannot find a post which describes this specific task so I feel it may be a case of several smaller tasks coming together at once.
Thanks in advance.