Advertisement

Building Reports

  • Brian McDonald
  • Shawn McGehee
  • Rodney Landrum

Abstract

In the previous chapter, you laid the foundation for your first report by creating a query and subsequent stored procedure. You also learned about the fundamental elements used to build reports and are now familiar with the design environment. Now, it is time to put all the pieces together and begin building reports. You can easily apply the concepts introduced in this chapter to any company that uses SQL Server and relational database systems. This chapter will focus primarily on creating a reporting solution based on data from a SQL Server health care database; it will use many of the report elements that have been available since SSRS’s inception in SQL Server 2000 through 2012. SSRS 2008 and 2008 R2 introduced many new features such as report variables, enhanced charting, and data visualizations. The most significant additions were the Tablix data regions and dashboard style elements like Sparklines, Data Bars, and the Indicator. We are excited to incorporate these significant and long-awaited enhancements into the reports featured in this book.

Keywords

Report Variable Column Group Visit Count Property Window Page Break 
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