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.