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 insights into how one can build custom report item solutions include: documentation overview, sample, and a great MSDN magazine article by…


Using Teradata’s .NET Data Provider

Reporting Services 2008 RS 2008 includes full support for Teradata-based report models. You can create and use semantic models based off Teradata similar to how Reporting Services already supports this for SQL Server, Analysis Services, and Oracle. Furthermore, RS 2008 includes a Teradata data extension directly in the box.  Among other features, that data extension provides full support for multi-valued query parameters in…


Reporting Services 2008 Information Aggregator

Want to get an overview, recommendations for good books and other resources, and the latest information about Reporting Services 2008? Check out our MSDN aggregation page for Reporting Services.  Looking for the latest downloads for Reporting Services 2008? Take a look at my RS 2008 resources page.  Furthermore, research and ask questions on the updated MSDN forums for Reporting Services….


RDL 2008 Specification

Our documentation team made the latest RDL specification available on the Reporting Services site: The 2008 RDL specification is available as XPS and as PDF document.  Older versions of the RDL specifications are still available: 2005/01 and 2003/10.


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 popup menu.   You can choose from a variety of pre-defined and parameterized formulas for the derived…


Technical Note Series on Reporting Services Performance and Scalability

  Over the past few months, I contributed to a series of technical notes by my esteemed colleagues Denny and Lukasz on The technical notes provide guidance on how to build, deploy, and optimize large scale SQL Server Reporting Services (SSRS) environments.  We derived some of the best practices from internal as well as external enterprise SSRS deployments. So…


Speaking at SQL Server Energy Conference

The SQL Server Energy 2008 Conference takes place in Vienna, Austria, on November 25th and 26th.  The conference covers a broad spectrum of SQL Server 2008 technologies, and provides great information on how to make the most effective use of new features. Speakers include well-known industry experts such as Rafal Lukawiecki, Al Comeau, Itzik Ben-Gan, Dejan Sarka,…


See You at PASS Summit …

The PASS Community Summit 2008 is a don’t-miss event for Microsoft SQL Server professionals. Whether you are a database administrator or a business intelligence professional, I believe you will benefit from the most up-to-date and comprehensive SQL Server knowledge available – take a look at the session grid. In addition to SQL Server MVPs and numerous SQL Server…


All Things Data Visualization (Sparkline Reports, Silverlight Charts)

My colleagues Sean Boon and Alex Gorev recently started their own blogs with focus on data visualization.  You can expect to see more postings on their blogs in future on how to effectively utilize Reporting Services 2008 charts and gauges to make your reports really stand out.   Sean started his blog with a great initial posting on how…


Charts with Dynamic Height or Width based on Categories/Data

You may have been in this situation before – you designed a chart based on a particular dataset and everything looks great.  However, later the data volume increases, or new categories dynamically show up in your data source, and there is not enough horizontal/vertical space in the chart to show all the data or categories.  Unless, of course, you…