I have had the same issue for years. MC's hard copy reporting capabilities are not particularly good. However, at some point hard copies become problematic when you get large file sizes.
In any event, here's how I solved the problem.
I copy the library over to an excel spreadsheet (or Access or ?). I used to print that spreadsheet but no longer do. You can then manipulate to your heart's desire, including just showing albums, etc.
I have never found a way to easily export to a spreadsheet, however. If someone knows, please let me know. Here's what I do (hopefully, I am remembering correctly).
1. Create a view with the fields you want.
2. Get all the records you want into that view (that is not always easy for me, but I won't get into that)
3. highlight (select) the first 6,000 records (I can't get it to work with more) and copy and paste into spreadsheet.
4. then proceed to next 6000 records, etc.
Kind of a pain, but it works. Maybe others have better ideas.