I understood you to mean that you could have several different ways the manager wants to look at the data. If it is only those 2 then I would do as Steve has suggested.

To be honest, I have always preferred to write static reports for specific purposes. This way you can more easily optimize the T-SQL.