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.
KeywordsReport Variable Column Group Visit Count Property Window Page Break
Unable to display preview. Download preview PDF.