• You stated “Management needs to be able to review any combination of cost centers based on their criteria on a timely basis”. You should look at something else than a SSRS report, when your requirements are that dynamic. Remember that the in-memory solutions out there only have to execute the query once for any combination of cost centers, while a report will execute the query for most combination changes.

    I would try Power View, based on the limited information you gave, it could be Power Views sweet spot.

    Since you use the evaluation version of SQL Server, you are probably not set on the technology, consider trying other vendors like Tableau, Spotfire or Qlikview. They all offer free trials.