More good news! ReportServer 3.1.0 will support Amazon Redshift datasources!
Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data. It allows you to run complex analytic queries against petabytes of structured data.
Further, your beloved pivot reports for dynamic lists will support Amazon Redshift datasources because of the JDBC mechanisms of ReportServer!
Your ReportServer Team