Currently, we do not have an out of the box report that shows project by role and their hours. You would need to create it.
If you would like further assistance building the report, please allow me suggest the following options:
1.) We can have our professional services team build this for you. For that we would need to understand your requirements in order to provide you with a quote or estimate. The next step is to contact your Clarizen Account Executive who can help you initiate the process.
2.) You can also join our free Office Hours Webinars (http://www.clarizen.com/live-demo.html#second). These are great resources for customization help with our experts and provides visual answers to your questions. One of our Customer Success Managers will be able to demo some examples for you and give you guidelines how to build it yourself.