Reporting Services 2008 Service Pack 2

SQL Server 2008 SP2 provides a roll-up of previous cumulative updates and also contains enhancements for Reporting Services SharePoint integration. Report servers with SP2 can integrate with SharePoint 2010 products. SP2 also provides a new add-in for integrating with SharePoint 2007 products. In addition, the new add-in supports the integration of SharePoint 2007 products with…

0

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

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…

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 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…

5

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

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: Shrinking Hidden Static Table Columns

Reporting Services 2008 introduced the ability to dynamically hide table columns and shrink the width of the table (and the report body) at the same time automatically. That said, you also have the ability to just hide the contents, but not the actual table column and preserve the space. I see this question come up…

0

Reporting Services Recipes Book Downloads

The Reporting Services Recipes book contains detailed step-by-step instructions and explanations for each report design recipe.  We also know that readers want to learn at their own pace, and sometimes don’t have the time to go step-by-step, but instead want to play with the final report first and then explore how it was built.  As…

0