Introduction to Reporting Services Design with SQL Server Data Tools
The professional lines separating system administrators, DBAs, and developers are blurring. Products are often extensible through code or at least have the potential to create functionality that goes well beyond that of out-of-the-box offerings. SSRS is such an application. The days of the Microsoft Management Console (MMC) are numbered and will be overshadowed by the new interface on the block, the IDE, though even that isn’t new by any means, as any developer will tell you. However, system administrators, DBAs, and even report designers have had to become familiar with this new way of performing their day-to-day tasks. As you’re probably well aware, you can create reports for SSRS within Visual Studio 2005 and up, or within BIDS/SSDT. To remind you of these abbreviations, the designer included with SSRS 2005 through the 2008 R2 release was labeled as Business Intelligence Development Studio (BIDS). However, in the 2012 release, Microsoft decided to re-label the designer as SQL Server Data Tools (SSDT) because of the inclusion of features such as further development integration with SQL Azure environments. The ability to use SSDT/BIDS is advantageous for Visual Studio developers, because now they can use the same IDE for report creation and application development! For the rest of us, creating reports in Visual Studio 2010 presents a learning curve.
KeywordsVisual Studio Reporting Service Query Parameter Report Object Dataset Property
Unable to display preview. Download preview PDF.