-
Indicators , a new feature of Reporting Services 2008 R2, let you show images for state values on your reports and avoid using custom images and expressions. Sean Boon's recent blog shows you how to scale the indicator images. One annoying issue business users reported when working with indicators...
-
Microsoft released the Microsoft SQL Server 2008 R2 Feature Pack. Among other things, it includes Report Builder 3.0, Reporting Services SharePoint Add-in, and PowerPivot for Excel.
-
My presentation "What's New in Reporting Services 2008 R2" for the local Atlanta.MDF group went well last night. We had some 80 people attending and I had some great questions. Too bad I couldn't beat my previous attendance record. I guess rain and traffic were deterrent factors. Thanks...
-
One new R2 feature that I discovered while reading the Reporting Services Recipes book , is group data synchronization. Consider the following report (download the two sample reports here ): In this report, the matrix region is nested inside a list region. The list region pages (groups) on product while...
-
Open Data Protocol (OData), previously known as ADO.NET Data Services, is quickly gaining popularity as a web protocol for querying and updating data. A few Microsoft products already expose their functionality as OData services, including SharePoint 2010, SQL Azure, and Reporting Services (see my blog...
-
Robert Bruckner announced that SQL Server 2008 R2 was released to manufacturing today. Robert summarized the most important most features. I covered them in my blog as well. I'll update this blog once I find out when R2 will be available on MSDN. UPDATE According to this Microsoft blog , R2 will...
-
In a previous blog , I introduced one of the new SSRS 2008 R2 feature: reports as data feeds. As I said, the R2 release will include a new Atom Data Feed renderer to produce an Atom service document (*.atomsvc) which defines a feed(s) per data region. I also said that the main scenario for report feeds...
-
Microsoft announced release dates for SQL Server R2, SharePoint 2010, Office 2010, and Visual Studio 2010. According to the Microsoft SQL Server Team Blog : SQL Server 2008 R2 (aka SQL 2010) will be listed on Microsoft's May price list, and will be available by May 2010 According the Microsoft SharePoint...
-
There was a huge discussion thread about the BIDS-Visual Studio integration story in the SQL Server 2008 timeframe where customers complained that BIDS got married with Visual Studio. This required switching both BI and code projects at the same if you want to have a solution with both project types...
-
After covering the cool new stuff in R2, it's time to talk about the uncool. One R2 change that really vexes me is RDLOM. RDLOM, short for Report Definition Language Object Model, lets developers program RDL in object-oriented way as opposed to using XML. RDLOM could save you a lot of effort when...
-
Two new data providers will be included in the SQL Server 2008 R2 release of Reporting Services, Microsoft SQL Azure and Microsoft SQL Server Parallel Data Warehouse , that will let you report from SQL Azure and SQL Server 2008 R2 Parallel Data Warehouse (code named Madison) databases respectively. I...
-
When Report Builder 2.0 shipped , it introduced local and server preview modes. If the report uses local references only, such an embedded data source(s), Report Builder 2.0 executes the query and renders the report locally just like the BIDS Report Designer. However, when the report uses a server reference...
-
A couple of Report Builder enhancements in SharePoint 2010 integration mode caught my attention. First, Report Builder 3.0 now launches by default when the Open in Report Builder action is initiated inside SharePoint 2010. Previously, Report Builder 1.0 would be launched. Second, if the report includes...
-
Here is a little gem for developers programming Reporting Services. SQL Server 2008 R2 brings a new web service endpoint, ReportService2010 , which merges the functionalities of the ReportService2005 and ReportService2006 endpoints. The new endpoint can manage objects on a report server that that are...
-
R2 brings several SharePoint enhancements, including: Support for multiple SharePoint zones – Previously, SSRS supported access from SharePoint URLs in the default zone, as I explained before. Support for the SharePoint Universal Logging service - Reporting Services introduced a new server interface...