I've using SSRS for some time and find it largely adequate for most analysis based reporting. I agree with another reply about "dumbing down" some of the adhoc reporting tools. Our biggest problem with adhoc reporting in general is not the software to produce the reports but the retards producing them who have (apparently) no understanding of data quality or what they are doing from the larger sense. We constanly get back reports from our clients that such and such a report is "total crap". If it were up to me I ban adhoc reporting!
Go Shockers! -WuShock