Advertisement

Report Authoring: Designing Efficient Queries

  • Brian McDonald
  • Shawn McGehee
  • Rodney Landrum

Abstract

SSRS provides a platform for developing and managing reports in an environment that includes multiple data sources of information. These data sources can include both relational data (for example, SQL Server, Oracle, MySQL, and so on) and non-relational data (for example, Active Directory, LDAP stores, and Exchange Server). Standards such as ODBC, OLE DB, and .NET facilitate the retrieval of data from these disparate data stores, so SSRS can access the data as long as your system has the relevant drivers. In the SSRS report design environment, configuring a dataset that drives the report content is the first step of the design process.

Keywords

Execution Time Service Type Execution Plan Query Optimizer Query Performance 
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