SSRS Report Builder - Issues From Experience?

Question

I'm looking into the idea of rolling out the web-based SSRS Report Builder to our end users to allow them to create their own reports against our production application databases. From what I have seen so far, this tool is easier to use than the VS Biz Intel Studio report designer, plus it is easier to install, and deploying the reports is much more understandable for an end user (plus the biggest thing is no SQL I guess).

Does anyone have any thoughts or experience on the pitfalls of giving users this kind of power? Right now, we get a lot of requests to export the data to a flat file so they can read it in and then build reports in Access against it, so I figure SSRS would be better than Accesss...