Jon hits the key points very well in his article.  Reporting Services is kind of the "sleeping beauty" of the SQL Server toolset.  Once awakened, it really dazzles the users that see it.  SSRS has been very well received where I work, having replaced scores of Crystal Enterprise reports.