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. So, it is time to put all the pieces together and begin building reports. You can easily apply the concepts 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 2005 plus several new features available in Reporting Services for SQL Server 2008. SSRS 2008 introduces many new features such as report variables, enhanced charting, and data visualization. The most significant addition is that of Tablix data regions. We are excited to incorporate these significant and long-awaited enhancements to the reports featured in this book.


Report Variable Visit Count Property Window Page Break Home Health Aide 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Rodney Landrum, Shawn McGehee, and Walter J. Voytek III 2008

Personalised recommendations