Home » reporting services » Using SharePoint Designer 2010 to Manage the Reporting Services for SQL Server 2008 R2 Add-In for SharePoint 2010

Using SharePoint Designer 2010 to Manage the Reporting Services for SQL Server 2008 R2 Add-In for SharePoint 2010

Rehmani Consulting, Inc. offers a unique set of video training content on the opportunities presented to LOB organizations as well as enterprise IT to implement “no code” methods with Reporting Services 2008 R2 to build custom automated processes that can service organization-specific needs. The set of content, SharePoint Designer 2010: Reporting Services.

To recap, Reporting Services 2008 R2 as an Add-In for SharePoint 2010 can be used to produce BI reports, and, even, dashboards created from sets of reports that can be published on SharePoint 2010 web apps for user access via commonly available web browsers. The task of producing this BI information is likely to be substantially lower than would be the case if programming experts were used to produce the same information with alternative methods like CSS, XSLT or Javascript.

It may well make sense to provide LOB users and/or enterprise IT organizations with in person training on specifically how to use this Reporting Services Add-In for SharePoint 2010. However, it certainly makes sense to, at least, consider purchasing a set of video training content like our offering. Video training content can be repeated, as frequently as required, to ensure user retention of best practices. As well, video training content can be accessed as needs arise, in other words on demand. Finally, with our VisualSP Help System for SharePoint this video content can be accessed directly from a SharePoint computing environment via the Ribbon.

The training set (authored by Bruce Herz) covers technical topics, including:

  • an introduction to Reporting Services and Report Builder 3.0
  • Installing SQL 2008 Reporting Services R2 Add-in for SharePoint 2010
  • Report Builder 3.0 Design Concepts and Creating Shared Data Sources and Data Sets
  • Working with Report Parts and Datasets
  • Introduction to Tablix Data Regions
  • Tablix – Table Template
  • Report Parameters
  • Report Expressions
  • Sparklines and Databars
  • Gauges and Indicators
  • Drill -Down, Drill-Through and Sub-reports
  • Report Charts
  • Report Maps

Users who master this set of techniques may have all of the instruction they require to implement the Reporting Services Add-In, and, thereby, exploit the feature set to produce highly useful BI information. Further, our training content includes instructions on how to use SharePoint Designer 2010 to build workflows for applications of Reporting Services features without recourse to hard programming. We think most LOB organizations and enterprise IT organizations will agree that it makes sense to explore “no code” process development opportunities. In particular, implementing a “no code” process development methodology permists LOB users, in particular, to contribute to the design, production and administration of automated procedures. By including these users in the process development process, we think enterprise organizations have a better chance of building truly useful automated procedures, and, thereby, improve their chances of capturing meaningful ROI from their efforts.

In the next post to this blog we will look at our purchase offers for our training content and where it may make sense for enterprise businesses to consider a purchase that provides unlimited, enterprise-wide access to this content.

© IMB Enterprises, Inc. & Ira Michael Blonder, 2012 All Rights Reserved
on behalf of Rehmani Consulting, Inc.