I've been tasked in developing a report or a utility that gives the ability for users to query our CMS database for any filters they need. we use SSRS as our reporting tool right now, but I don't think this would be an adequate solution for this type of report. I've looked into power pivot but also don't think that would work considering the amount of data we currently have.
Can anyone help with any suggestions of the best way to approach this project?
Thanks in advance,