What I've done is made queries, filtered out what I don't want to see and created a report. However, if you were to make several different reports, you would have to create just as many queries that correlates with each report. It may be inefficient and doesn't involve any VBA, but it works for me.