Introduction to SQL Server Reporting Services (SSRS)
Microsoft has provided us with an easy to use and feature rich reporting service since SQL 2000. Now with the newest 2012 version, we have almost all the features available that we ever could ask for! And amazingly, we can even have it all for FREE in the Express edition, if we want! In the first 50 min of this introduction we will be looking at how to install and configure SSRS 2012, how to build a simple report with it using the included Visual Studio, and finally, how to set automated periodic generations of the report using the client front end. In the second 50 min of the evening, we will be looking at more complex report types, how to add colourful and meaningful charts to your reports, and if time allows, we will look at extended formatting tricks and tips on the data columns and rows.
PLEASE NOTE: This session can be enjoyed by non-DBA’s, as the report creation system was designed by Microsoft to be understood by non-IT users. So feel free to bring along your super-user co-worker from the finance, sales, engineering or marketing department, who might be interested in building useful reports off your ERP, CRM, or other system!
Speaker: Martin S. Stoller
Martin S. Stoller (MCDBA, MCITP SQL DBA & SQL DEV 2005 & 2008) is a DBA, Programmer and IT Architect that learned SQL two decades ago using MS-QUERY and MS-ACCESS 1.0, and first came in contact with MS-SQL Server in its seminal version of 4.2. Currently working for Canada’s largest fuel distributor (Parkland Fuel Corporation) as their sole Microsoft Database Administrator, Martin specializes in legacy system upgrades and unorthodoxly complex ETL. http://www.linkedin.com/in/martinsstoller
Time: May 15th, 5:30PM, RSVP is required
Royal Jubilee Hospital - New Patient Care Centre
Located on the Southeast corner of Richmond and Bay Streets. In the main foyer, there is a large walkway marked to “Patent Rooms” that leads toward an elevator bank. There is a gift shop on the left of this walkway. Do NOT go towards the elevators; instead follow the smaller hallway to the left of the gift shop. The lecture theatre (Room S169) is located on the right at the “T” hallway intersection.