Reporting From Analysis Services Data

The SQL Server Customer Advisory Team published a new technical case study on Analysis and Reporting Services, Design and Implementation.  You can read the summary here, as well as download the full 55 page document. Among other topics, the case study explains how to use so-called server aggregates in reports calculated by Analysis Services, report…


Kerberos Troubleshooting

Adam Saxton posted his great Kerberos troubleshooting guide, which covers both Reporting Services in native mode as well as SharePoint integrated mode configurations: If you are specifically troubleshooting Kerberos with a Reporting Services 2008 deployment, you may also want to check out the following whitepaper: Update (July 18): A new whitepaper for Configuring…


Debugging Custom Extensions with Visual Studio 2010

If you are developing custom extensions for Reporting Services (such as a data processing extension, delivery extension, security extension, rendering extension, report definition customization extension) with Visual Studio 2010, you have to make sure you compile the extension for the .NET 2.0/3.5 CLR because current versions of Reporting Services run in the 2.0/3.5 CLR, and…


Reporting Services 2008 Resources

Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services!  Research and ask questions on the updated MSDN forums for Reporting Services. Important downloads for Reporting Services: SP2: Report Builder 2.0 (SP2 Download)for Reporting Services 2008 (build 10.00.4000)  SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279) SQL Server 2008…


Reporting Services 2008 R2 Resources

SQL Server 2008 R2 was released to manufacturing on April 21, 2010.  You can read more about it here. RTM downloads already available:  Report Builder 3.0 RTM  SQL Server 2008 R2 RTM – Developer Trial Edition SQL Server 2008 R2 RTM – Express Edition with Advanced Services SQL Server 2008 R2 RTM – Documentation SQL Server 2008 R2…



SQL Server Reporting Services 2008 R2 introduces the RDL 2010 format with enhancements such as Maps, shared dataset references, page breaks , as well as RDL expression language additions such as Lookup, and aggregates of aggregates. You can now download the RDL 2010 specification as XPS file.  You can still download specifications for previous RDL…


Reporting Services 2008 R2 SharePoint Integration

My esteemed colleague Prash Shirolkar put together blog postings with helpful tips for: Integrating Reporting Services 2008 R2 with SharePoint 2010 Integrating Reporting Services 2008 R2 with SharePoint 2007


Kerberos Authentication and Reporting Services

When deploying Reporting Services in an environment that requires more than one server, such as a scale-out deployment or a deployment in a server farm, you may need to configure Kerberos authentication. Kerberos is particularly important when you require domain accounts to authenticate users but don’t need to pass user credentials to the database that…


Report Design: Naming Excel Worksheets

One of the frequent feature requests for Reporting Services was to add the ability to define data-dependent names for worksheets when exporting to Excel. Reporting Services 2008 R2 adds this capability through a more general feature to name pages.  In Excel export, report page names determine the name of worksheets. The report item with the…


Report Builder Portal

Are you looking for how to get started with Report Builder 3.0? videos and tutorials of how to create report parts? news about and downloads for Report Builder? pointers about Report Builder report design capabilities, such as sparklines and data bars, gauges, indicators, maps, creating drillthrough reports, subreports, page layout and rendering? If yes, you…