Granular Security in SQL Server
Using the GRANT Shema permissions on my made-up ReportUsers domain group, I can assign SELECT permissions as follows:

GRANT SELECT ON SCHEMA :: dbo TO [domain\ReportUsers];


For the Reporting schema, that can be tackled in a few ways. Do you want to give them full control over the schema? Is it just for creating views?