Power Users and Information Workers can Avail of Report Builder 3.0 Benefits With Reporting Services Add-In for SharePoint 2010

Broadly identifying likely benefits that line of business (LOB) organizations can obtain through the use of a tool like Report Builder 3.0 is not an easy task. But, given the past few posts to this blog, which we wrote to present the benefits to these same LOB organizations, as well as to the enterprise IT organizations that are charged with supporting them, of using the Reporting Services Add-In for SharePoint 2010, Enterprise Edition, we thought it would make sense to speak a bit about a tool that is a step further removed from SharePoint, but, nevertheless, a core component of…
Read more →

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…
Read more →

Use the Report Viewer Web Part for SharePoint to Display SQl Server 2008 R2 Data as a Report or Build a Dashboard to Display Multiple Reports

Microsoft’s MSDN web site offers a set of documents on the Report Viewer Web Part (Reporting Services in SharePoint Integrated Mode). For readers who are not familiar with how the term “Report Viewer Web Part” is used by Microsoft, it is important to understand that the same term is used for two very different set of web parts. A short presentation of this potentially confusing broad use of the same terminology is explained on Report Viewer Web Parts for SharePoint, one of the blogs on MSDN. In sum, it is important to understand that a version of Report Viewer Web…
Read more →

Training Site Owners, Citizen Developers, and Higher Level Users of SharePoint 2010 in the SQL Server Reporting Feature Makes Sense

In the prior post to this blog we made a case for SharePoint 2010 Reporting Services as a particularly high value feature. To summarize, enterprises can certainly benefit from availing of SQL Server Reporting Services, which are based on XML, and, therefore, can be displayed (at least in raw form) with any of a very wide set of commonly available web browser clients. The challenge, however, is how to package this database information in a manner that permits these very low cost web browser clients to display highly intelligible reports, rather than simply raw XML data. At least 3 of…
Read more →

SharePoint 2010 Reporting Services Add-In Delivers Benefits that can Drive User Adoption

In our opinion, Microsoft® greatly expanded the utility of reporting tools for SQL Server back in 2004 by choosing to base them on ” . . . the Report Definition Language (RDL), which is an XML-based standard for defining reports. RDL is key to the Reporting Services success by allowing third parties to publish reports to the Reporting Server. There are already product offerings from independent software vendors (ISVs) today.” (quoted from “Introduction to Microsoft SQL Server Reporting Services” by “Crowe, Chizek and” Company, LLP, published on April 12, 2004 on the TechRepublic® web site). The simple explanation for our…
Read more →