You would need to develop your own custom report for what you are looking for. Under the Report tab, click on Custom Report and right-click to create your custom report.
Normally, for different types of backup, you woul require different retention policy, i.e. how long do you want to keep the data for. For example, you may want to keep your daily backup data for 1 week and your weekly backup data for 1 month. If you lump all the tape in one media set youi can only set the overwrite protection period once. Everytime you need to change the overwrite protection period, you need 1 media set.
Once the tape is associate with a particular media set, it will remain in that media set until it is associated with another media set. A job that targets that media set will use the tapes in that media set before using tapes from either the scratch media set or other media set.
To cut the long story short, over time all your tapes will end up in one of the media sets that you have created and will remain in it forever. Unless all your jobs target one media set, your idea of having a gigantic scratch media set is not workable. The only way is manual intervention. For me, I move all my overwriteable tapes manually to the scratch media set. I do this as part of my daily monitoring chore.