rehabbed the report route test

This pull request has all the commits of the crud pull request as well.