This is pretty much what reporting solutions like crystal reports and reporting services were designed to do. It's not complicated.

I highly recommend Jessica Moss's stairway to SSRS as an introduction to creating reports.

http://www.sqlservercentral.com/stairway/72382/[/url]

MSDN codeplex has plenty of sample reports[/url] that run off Microsoft's sample database "Adventureworks".

You can get a dev copy of SQL Server very cheap, download and attach the adventureworks database and run these sample reports.