If you have Microsoft SQL Server then you can go ahead with SSRS as reporting tool. Have a general read on it
here[
^].
If you want to have third party software for the same then you can go for
Crystal Reports[
^].
SSRS is the preferred one these days based on MS product and clubbed with SQL server. If starting from afresh (which sounds like), I would recomment using SSRS for it. It has the features you need/said in the question.