I am excited about SQL Server 2012 Service Pack 1 Cumulative Update 4 , released today, which provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1...

Several projects kept me very busy over the past year. I will talk more about a few of these in subsequent postings now that some are publicly disclosed in the meantime. In this posting, I am very happy to announce the availability of “ Professional Reporting...

Today SQL Server 2012 RC0 was released. You can download it here: http://www.microsoft.com/download/en/details.aspx?id=28145 . This post summarizes much of the new functionality in Power View with RC0. Related information: TechNet page and TechNet...

There are many new exciting capabilities in CTP3 for Reporting Services. More details can also be found on the Reporting Services Team blog , with a brief overview below. SQL Server “Denali” CTP3 is now available for download: https://www.microsoft.com...

A number of announcements were made at today’s PASS conference keynote, including Parallel Data Warehouse and Project Atlanta . Denali CTP1 is available for download now, and contains many enhancements across SQL Server. As for Reporting Services...

At today morning’s PDC 2010 keynote, SQL Azure Reporting was announced! SQL Azure Reporting enables developers to embed operational reports on information stored in a SQL Azure database, using ReportViewer in remote mode in your applications...

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

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

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

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

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

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

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

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

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

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

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

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

The Feature Pack for Microsoft SQL Server 2008 R2 was released for download earlier this week, and includes PowerPivot for Excel 2010 , as well as Report Builder 3.0! The stand-alone download package for Report Builder 3.0 is available here: http://www...

One of the design principles of the Reporting Services platform is that you author a report once, and it then renders to all interactive and export formats with as much fidelity as possible (and enabled by the underlying export format). You don’t...

Teo Lachev is a well-known Reporting Services MVP, speaker at conferences, and authored several Reporting Services and Analysis Services books in the past.  Teo recently wrote a book review of “ Reporting Services Recipes – for Designing Expert Reports...

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

One of the frequent feature requests for Reporting Services was to add the ability to reset page numbers within the report, e.g. based on a change in the group value. Reporting Services 2008 R2 adds this capability through a more general feature to name...

Besides releasing Reporting Services in SQL Server 2008 R2 , we were busy working on a number of improvements for the Reporting Services SharePoint Add-in as well. SharePoint 2010 Reporting Services Add-in The SharePoint 2010 pre-requisite installer now...

In case you missed it in the recent wave of SQL Server, Visual Studio, and Office release announcements, Visual Studio 2010 was released in mid April and includes significantly enhanced ReportViewer controls. In server mode, the ReportViewer control can...