• I have used SSRS for like this (as both a data input and for data retrieval) and think SSRS is terrible for this. The main problem is that you have no way to control the parameter behavior (an area where SSRS is very week). Better options, which depend on budget and available skill set, include:

    1. MS Access as a front end and SSRS for reporting

    2. ASP.Net from scratch (using Web Forms or whatever is hot these days [I'm not a .NET developer])

    3. ASP.Net MVC

    4. SharePoint

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001