August: No Meeting Enjoy your summer!
Next Meeting: San Francisco – Wednesday, September 8 - 6:30 pm
SQL Server Reporting Services in a Development Context
Presented by: Lisa Nicolls of ECWise
SQL Server Reporting Services does a lot to streamline and de-mystify the process of getting great BI results from your data. However, at least for now, it doesn't do a lot to integrate reporting with standard practices, whether you're a SQL or a .NET developer.
In this session, we'll look at some tools and practical methods for developing reports consistent with your usual working habits, and exposing them consistent with your users' expectations.
We will:
- Compare and evaluate different syntax and methods that SSRS provides for sending and rendering output
- See various tips and tricks for improving RDL results to resolve some common user requests
- Look at using the RDL's containership model effectively, and discuss why some things seem to be harder than they ought to be
- Evaluate different places to put the query code and different levels on which query parameters can be placed
- Investigate using RDL data output (XML format) as an interim output format and a testing device
- Notice what difference RS 2008, and R2 in particular, have made to some of our practices.
Demo: You'll see examples of existing reports and RS exposure methods, as well as some development tools designed to make your RS life easier. No commercial products will be demonstrated. .
Lisa Nicholls is a Microsoft Technologies Practice Manager and Solutions Architect for EC Wise, a BI-focused consulting company in San Rafael. Previously, with Colin Nicholls, she provided enterprise data integration and analysis services using XML in a variety of environments and languages (dba Spacefold). She has worked as a contractor to the MS Visual Studio Data team in many capacities, ranging from Program Management to Dev to Test to User Ed, and has a special interest in reporting tools of all kinds. She blogs on SSRS-related topics at Spacefold.
Location Microsoft Office at 835 Market Street, Suite 700, San Francisco, CA 94103. Click here for a map
To RSVP or for more information, email Mark Ginnebaugh at mark@designmind.com
Cost No charge
6:30 to 7:00 pm - Introductions, food, networking
7:00 to 8:30 pm - Presentation and Q&A
The San Francisco SQL Server User Group focuses on database development and administration practices specifically centered around Microsoft SQL Server. Presentations include developer centric interactive sessions as well as demonstrations of related products that have been judged to have potential value or be of interest to the professional database community. We also offer a face to face forum for peer learning and networking.
Mark Ginnebaugh, User Group Leader, is the President of DesignMind, a Bay Area developer of Websites and Database Applications. Send User Group-related questions and suggestions to mark@designmind.com