Generate issues report

What I'd like to do is to generate a report which runs against all files in a solution and reports the number of issues per file.  The issues that I want reported are those which represent Warnings (yellow) or Errors (red).  I do not want to report Hints or Suggestions (green).  I say this because the practice that our development team follows is that code should have a green box in R#, i.e. no warnings or errors.

What I want to do is to have a compliance report sorted such that high offenders appear first.  Something like:

a  25
b 23
c 21
d 1

I know how to Inspect Code Issues in Solution.  I also know how to export that report and edit it such that it is in the format I want.  What I do not know is how to set Filter Issues such that only Warnings or Errors appear.

What I would really like is to have the ability to have a tool which fails the build when this occurs.  Sort of like the ability to run FxCop from the command line.