The description of the requirement here is not very clear to me. Would it be possible to include more details and possible an example that shows a sample output.

We would like two types of graph reports that the base data (Projects $ Versions) is driven from a selected filter.
The first graph we are looking for is “Status Report” similar to the current “Cumulative By Date” just with the status: Open (All status but Resolved, Closed & Suspended), Resolved & Closed.
The second is “Distribution Report” similar to “By Category” but for every Subproject and show status of All Open issues (All status but Resolved, Closed & Suspended)

Your reports have a time dimension which we don't have a well structured data for. For some of the data like status changes, we can probably hack it using the issue history. However, for distribution it is not as easy since this is not in the history. Also the history is not designed to be a feature to base reporting on. I don't think it will scale with huge data since the data is not a format that can be easy aggregated using SQL.

Sometime ago I have written some requirements relating to this issue. The idea is to regularly aggregate the data and make such aggregated data available for reporting:
http://www.mantisbt.org/wiki/doku.php/mantisbt:performance_counters_requirements

We would also like this ability to create a filter that is for resolved issues that are not suspended. This ability to add not would be good for other filter items as well.

The code for this feature was submitted in late 2007.