Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Report Design   (RSS)
SQL Server 2008 R2 November CTP – What’s New In Reporting Services?
The November CTP download is available for MSDN and TechNet subscribers. The public download is available here . The feature pack download is now also available and includes Report Builder 3.0 as well as the RS add-ins for SharePoint 2007 and SharePoint Read More...
RS Maps with Spatial Data and Bing Maps
SQL Server 2008 R2 August CTP includes map visualization functionality in Reporting Services , as briefly described yesterday. In this posting, I’m going to provide an introduction of how to use spatial data and Bing Maps with Reporting Services Maps. Read More...
SQL Server 2008 R2 August CTP – What’s New In Reporting Services?
The August CTP download is available for MSDN and TechNet subscribers. The public download is now also active here . The Data Platform Insider blog provides an overview of what's new in this first public CTP release for SQL Server 2008 R2. If you are Read More...
Tablix – Multiple Subtotals Are Easy (aka Goodbye InScope)!
Reporting Services 2005 with Matrix In a matrix in Reporting Services 2005, accomplishing multiple or different subtotal calculations at the same grouping level was difficult, but possible. If you wanted to accomplish custom subtotal calculations in RS Read More...
Multi-Player Gaming in RS (aka BI Power Hour 2008)
At the traditional annual “BI Power Hour” sessions, several teams that contribute 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 Read More...
SQL Server 2008 SP1 and Report Builder Update
Service Pack 1 for SQL Server 2008 is now available for download . The service pack is primarily a roll-up of Cumulative Updates 1, 2, and 3 and minor fixes made in response to requests reported through the SQL Server community. While there are no new Read More...
Tablix – Stepped Layout
Tablix enables the separation of data groupings and layout header areas.  A stepped layout can help with horizontal spacing, because nested groups can then share the same horizontal space, which was previously not possible in a matrix layout.  Read More...
Dynamic Drilldown in Reports and Charts
Just a quick post to reference two interesting reads about designing dynamic drilldown in reports: Sean Boon blogged about an approach to implement drilldown on charts with Reporting Services when Analysis Services is used as the data source. Chris Webb Read More...
Tablix – The Matrix Revolution
Tablix is the new underlying flexible data region and grouping structure introduced in Reporting Services 2008. Among other features, it enables asymmetric layouts, as demonstrated in the thumbnail screenshot below. If you use a list, table, matrix, chart, Read More...
Report Surfer
I wanted to give some props to MVP Grant Paisley who has setup a site called Report Surfer , where you can directly view, share, and download sample Reporting Services reports. I met Grant a few months back when he visited Redmond. He was very interested Read More...
The Ultimate Guide to Color Scales / Conditional Formatting
I recently provided a tip to my Australian colleague David Lean to successfully solve a small report design challenge with tables and charts that use conditional formatting. The specific goal was to dynamically calculate and assign a color shade so that Read More...
Report Performance Optimization Tips (Subreports, Drilldown)
In a previous posting, I explained the new ExecutionLog2 view in Reporting Services 2008: how to utilize it to measure report execution performance, identify report candidates for optimizations, and verify the impact of the latter. I also included two Read More...
Custom Report Item
Custom Report Item in Reporting Services 2005 This server extensibility feature introduced in Reporting Services 2005 (RS 2005) provides the ability to develop custom report items for embedding in reports. Examples of resources available that provide Read More...
RDL 2008 Specification
Our documentation team made the latest RDL specification available on the Reporting Services site: http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx The 2008 RDL specification is available as XPS and as PDF document. Older versions of the RDL Read More...
Trendlines (Calculated Series) in Reporting Services Charts
One of the new chart features in Reporting Services 2008 is the ability to add chart series calculated from another series. This is accomplished by right-clicking an existing series (data point value) and selecting "Add Calculated Series ..." from the Read More...
More Posts Next page »
Page view tracker