Web reporting for business

Is there something out there that allows me to create web reports from my MSSQL server, but the reports are customized based on login to the site?

Something like SQL Reporting Services would be perfect if I could use a WHERE user='%USERNAME%' in the SQL and have the variable show that report with just the specific users' login name in it.

I'm afraid to ask if crystal reports does something like this cause I've heard its a bitch. or something like tying SQLRS into Sharepoint?