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
-- Itzik Ben-Gan 2001