Actually SSRS has an ad hoc tool called Report Builder that is pretty good. I use it for my customer base. It has security filters that you can put on your report data model to limit the data that is returned so that you can isolate 1 users data from the next. Although the filter can be a little bit buggy.
Database Systems Manager
Century Distribution Systems, Inc