Hi,
This can be achieved by designing this report in SQL Server Reporting Services (SSRS). SSRS provides all features you required as well export facility in Excel, PDF and Word.
I have 9 years experience in SSRS, ASP.NET, C# and SQL Server. Created complex reports with dynamic column/grouping, sub-report, drill-down, drill-through, Charts, Gauges, Indicator reports.
Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views.
Thanks