[Orgmode] export weekly completed/late items

[Kyle Farrell]

I'm trying to create a weekly report of items completed or
outstanding.  I'd like to bucket these by status.  I've got my entries
with a DEADLINE calendar date set.

For example given the org input:

* TODO Fix bug for software project X
   DEADLINE: <2011-02-07 Mon>
* DONE Update documentation for feature Y
   DEADLINE: <2011-02-09 Wed>
* DONE Scope out new version of Z
   DEADLINE: <2011-02-09 Wed>
* TODO Code new version of Z
   DEADLINE: <2011-02-17 Thu>

I'd like to bucketize these based on the current date TODO status.  If
the date is 2/11/2011, based on the deadline and the status I'd like
to see:

  Missed:
  2011-02-07: Fix bug for software project X

  Completed:
  2011-02-09: Update documentation for feature Y
  2011-02-09: Scope out new version of Z

  Coming up:
  2011-02-17: Code new version of Z


Am I best using an agenda view to create this?  Or would this be in a
custom exporter?

thanks!
-Kyle