SQL Server Reporting Services (SSRS) - Tips & Tricks

This article describes how to render a list of data sources and dataset's from with a Report Definition (.RDL) file, while using the SQL Server Reporting Services Web Services. [More]

In this article we will examine developing a method to handle stacked values within a field, while using a table or matrix. There may be multiple ways to handle stacked values approach, but we will focus on delivering the solution using a custom assembly. [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 2.0 for this example. [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]

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

In this article we will describe how to programmatically add a new Folder and Properties to the catalog list in Reporting Services. We will be using the CreateFolder and FindItems methods for this example. [More]

This article will demo the use of Reporting Services SOAP API to integrate with a web application. We will begin by creating a new Web Project in VS 2008 and configuring the web.config so we can authenticate using impersonation. Next, we will reference the ReportingService2005 web services proxy object. Then enter some code to render a list of reports from within the Report Catalog. [More]

This article will provide an example of how to create a Shared Data Source and publish it to your Report Server. You may use the data source while developing reports in Report Designer and Report Builder 2.0 tools. For this example, we will be using SQL Server Business Intelligence Development Studio 2008. [More]