I'm currently working on a data retirement initiative within my organization. We are retiring the data from 200ish application to a data repository. One of the things we're working on is a way for the users of these apps to be able to still view this historical data. 1 person could possibly need to view multiple sets of data.
I had started creating a SSRS that lists all applications a person can see and then had the idea of setting a dynamic subreport( as you know and I didn't know, this can't be done!!).
So, my question is, is SSRS an option for the front end? Or, do I need to build an ASP.NET front end with a report viewer control? Seems like this might be the best route.
Thanks in advance