6:00 – 6:30 Pizza and Networking sponsored by Intellectual Capitol

6:30 – 6:40 Announcements

6:40 – 8:15 Paul S. Waters: SQL Server Reporting Services Recipes

8:15 – 8:30 Closing remarks and give-a-ways (We have Windows 7 to give)

SQL Server Reporting Services (SSRS) is a powerful reporting system, yet some things are not has intuitive and straight forward as report designers would like them to be.  In this presentation we will cover four SSRS report design challenges.

Drill Through for a Multi-Level Matrix Report - We will learn how to get around the challenges of getting a drill-through to a report in a multi-level matrix report to work in SSRS 2005 and how to take advantage of improvements in SSRS 2008 to achieve the same results.

Sparklines - How to create Sparklines with SSRS 2008.  The principals covered in the recipe can also be applied to SSRS 2005 but the implementation is different.

Creating a Calendar Report - SSRS does not ship with a calendar report item, but this is not a problem since it is pretty easy to create one using a matrix in all versions of SSRS. 

Updating Data Within a Report - What?  That is just silly.  Reports display data; they do not update data.  Well, there are times this might be useful, and this section will show you how it can be done.

These solutions, and many more like them, can be found in the upcoming book from WROX, "Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports" 

Paul S. Waters, Business Intelligence Architect, AMECO (www.paulswaters.com )
During Paul’s 16 years of working in IT, he has held a variety of positions including help desk manager, application developer, network administrator and Director of IT. For the past several years, he has been focused on business intelligence and data warehouse design and development.  Currently he designs, develops and implements business intelligence solutions using the Microsoft BI stack.
 
Paul is the Founder and President of the SQL Server Innovators Guild (www.ssig.org), a founding board member of the GSA Technology Council (www.gsatc.org), holds a position on Greenville Tech’s Program Advisory Council, and was Co-Chairman of the South Carolina Code Camp 2.0 (www.sccodecamp.com).  He is also a presenter at local user groups and conferences.  Paul was also the Technical Editor for the book "Microsoft SQL Server 2008 Integration Services Problem-Design-Solution" and contributed to the forth coming Wrox book "Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports"