Another option is to use measures Sprint issues at closing which returns the count of issues at the moment when a sprint was closed (of course this measure works only for closed sprints).
And remember to use at least one measure in each report to bind your data together from different perspectives (dimensions). A measure is a treasure