Turn-Based Gaming Against AI in RS Reports (aka BI Power Hour 2009)

At the traditional annual “BI Power Hour” sessions several teams contributing to the Microsoft Business Intelligence platform show off their technology in a fun way.  It is about demonstrating, in perhaps unusual ways, of how business intelligence and various tools of the BI stack can be useful. In past years, Reporting Services made a number…

2

PivotViewer for Reporting Services

PivotViewer for Reporting Services makes it easier to interact with parameterized reports and large amounts of data in ways that are powerful, informative, and fun.  You decide at runtime which subset of data you want to look at and what (meta)data you associate with each card.  You can now download a technology preview of PivotViewer…

0

Kerberos Authentication and SharePoint 2010

A new whitepaper for Configuring Kerberos Authentication for SharePoint 2010 products has just been released.  Section 4 of that whitepaper specifically explains identity delegation for Reporting Services.  The whitepaper also covers SQL Server Analysis Services, PowerPivot, Performance Point Services, Excel Services, and others.

0

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: http://blogs.msdn.com/b/psssql/archive/2010/06/23/my-kerberos-checklist.aspx If you are specifically troubleshooting Kerberos with a Reporting Services 2008 deployment, you may also want to check out the following whitepaper: http://msdn.microsoft.com/en-us/library/ff679930.aspx Update (July 18): A new whitepaper for Configuring…

0

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…

0

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…

0

RDL 2010, RPL, RGDI

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…

0

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

0

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…

2

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…

0