Recently, I delivered a client presentation on SQL Server Reporting Services 2008. There were some follow-ups I thought I’d share:
Q. After creating and deploying an .RDL file to Report Manager, later, when I want to modify it, can I bring it back into BIDS?
A. Yes. Simply create a new, empty Reporting Services project within BIDS and then Add >> Existing, browse out and open the existing .RDL file. You may need to make some minor edits if you were using a shared data source.
Q. Compare Report Builder 2.0 with BIDS.
A. Reference this page: http://www.microsoft.com/sqlserver/2008/en/us/report-builder.aspx
Q. Compare SSRS 2008 for Standard and Enterprise SQL Server editions.
Additional, informative article: http://sqlserverpedia.com/wiki/SQL_Server_Standard_and_Enterprise
Q. Is there a freely available version of SSRS?
A. Yes. SQL Express optionally includes a scaled-back version of SSRS. Download here: http://www.microsoft.com/express/sql/download/
Q. Book recommendations?
A. I really like “Microsoft SQL Server 2008 Reporting Services”, by Brian Larson. http://www.amazon.com/Microsoft-Server-2008-Reporting-Services/dp/0071548084/