Where: Versa Trans Solution, Latham, NY
When: Tuesday, November 10, 2009 6:30-9PM
Who: Rob Fisch, Director of Global Technology at Kaz, Inc

Getting Started with Reporting Services

Overview

You've heard the hype and clammer about Microsoft Reporting Services. Rob Fisch joins us to unveil the covers on how to get started on using the Business Intelligence Development Studio (BIDS), a full IDE used to publish reports in a controlled and planned way. Microsoft also offers an adhoc reporting tool called Report Builder, however this will not be part of the presentation, but can be part of a discussion.

The journey begins with building a project from scratch with Visual Studio (SQL Server comes with it's own mini-version of Visual Studio...which is all you need). We'll cover building your data connection, planning the report project (in this context, what does a 'project' mean?), drilldowns and drillthroughs (and what the difference is),  parameterization, multiple datasets, adding your own SQL, security, basic and conditional formatting, SharePoint Integration, dashboarding possibilities and more...

Bio

Rob Fisch is currently the Director of Global Technology at Kaz, Inc (http://www.kaz.com). While wearing many IT hats, Rob's central role has been to integrate various technologies into single platform solution for reporting (with Microsoft SQL Reporting Services), collaboration (with SharePoint), and business process management (using a variety of workflow technologies).

He has worked with Microsoft SQL server since version 6.5 in various capacities (dba, developer, report developer, data warehouse designer) and with SharePoint (WSS2, WSS3 & MOSS2007), as system architect since 2003.

You can see some of Rob's published reporting tips at MSSQLtips (http://www.mssqltips.com/author.asp?authorid=3) or find out more about Rob at LinkedIn (http://www.linkedin.com/in/rfisch) or contact him directly at Rob.Fisch(at)yahoo.com.