We have a data warehouse and reporting system running on SQL Server 2008R2 and we have not touched CLR yet. All our needs have been met via the 'traditional' T-SQL route with reporting implemented in SSRS.