Advertisement

Introduction to Reporting Services Design with SQL Server Data Tools

  • Brian McDonald
  • Shawn McGehee
  • Rodney Landrum

Abstract

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.

Keywords

Visual Studio Reporting Service Query Parameter Report Object Dataset Property 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Brian McDonald, Shawn McGehee, and Rodney Landrum 2012

Authors and Affiliations

  • Brian McDonald
  • Shawn McGehee
  • Rodney Landrum

There are no affiliations available

Personalised recommendations