Nearly all of the presentations concerning SQL Server Reporting Services at the SQL Saturday conferences are about how to design reports. This one is a bit different, it’s about how to organize things on the server side.
The two most important points are to create a ‘shared data sources’ directory and a ‘linked reports’ directory. Make sure all developers use the same shared data sources and ALWAYS deploy into the linked reports directory using the same name the developer used. Doing so will help keep your SSRS server from becoming a mess.
The most interesting (though perhaps not most important) topic is the ReportServer database and how it can be used to create a Report of Reports. It’s a great way to untangle a SSRS server that’s a mess.
Enjoy!
Leave a Reply