In this article we'll show you how to use SQL Server PIVOT operator. The PIVOT operator is useful when you want to generate cross-tabular views to summarize data. [More]

In this session we'll show you how to create a Reporting Action using Analysis Services 2012 Cube Designer. We'll explain what a Reporting Action is, how to create one in SSAS 2012 and finally demonstrate how to render a SQL Server Reporting Services report by executing the Reporting Action from Excel. [More]

Recently, I've had a few requests for how to display a TreeView list of Report Parts from SQL Server Reporting Services Report Server Web Services. This article will demonstrate how to query a list of Reports, Datasets and Report Parts using Report Server Web Service EndPoints. For this session we'll be using the ReportingServices2010 EndPoint. [More]

In this article we'll show you how to create a custom Report Template for use with SQL Server Reporting Services. What is a Report Template? A Report Template is a custom defined .RDL file which you save to the ReportProject folder of SQL Server Data Tools (SSDT). The custom Report Template will render in the list of available Report Templates to choose from within SSDT. The benefit is Reusability and Brand Standards for authoring business specific reports. [More]

In this session we'll show you how to change a Sparkline series fill color when value(s) are either positive or negative. This session demonstrates how to work with Sparkline’s using SQL Server Report Builder 3.0 for authoring and designing the report. [More]

In this article we will examine how to design a Drillthrough Action using SQL Server Analysis Services 2012. The Drillthrough Action will include a Condition and multiple Drillthrough Columns. [More]

In this demo, we'll show you how to create a SQL Server Reporting Services report, using a SharePoint List connection type as the data source. [More]

I was looking for a way to configure Report Manager to open Report Builder 3.0, instead of the default Report Builder 1.0 application. I was able to find this tidbit from the Report Builder 3.0 online help and thought I'd share. [More]

This post will demonstrates how to upload an .RDL file to the Reporting Services database. We will begin with creating the method to upload the file and save it to a temporary folder. Next, we then consume the web service method CreateReport to save the .RDL file to the Reporting Services database. [More]

This article we will describe how to enhance a Pie Chart by using the SoftEdge or Concave value, using SQL Server 2008 Reporting Services. These values are available only on a 2D Pie Chart. The image below illustrates both SoftEdge and Concave styles, respectively. We will be using Report Builder 3.0 for this example. [More]