SQL Server Reporting Services (SSRS) has evolved over the years to incorporate many new data visualization capabilities. In this article, Scott Murray illustrates how DBAs can use these tools to produce reports that include Indicators, Embedded Charts, Sparklins, and Chart overlays.  Read more...

Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.  Read more...

DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To properly administer them, it certainly helps to understand the technology from the point of view of the user. By using an existing SSRS report as a data feed for Excel, Rodney Landrum explains how these users can now take advantage of development efforts in new ways.  Read more...

Most maintenance for SSRS is performed either in Report Manager online or within the Report Services Configuration Manager from the desktop. The SSRS Management Studio connection is certainly no replacement for either of these tools, however, several benefits can be obtained using SSMS. First, you are able to connect to the SSRS even if you are having browser issues; second, it is often quicker to just switch from using Management Studio for the Database Engine.  Read more...

Dattatrey Sindol shares his tips and tricks on SQL Server Reporting Services Report Manager. He provides guidance on Customizing Report Manager Header/Title, Uploading Custom File Types to Report Manager, and Enable My Reports Feature.   Read more...

You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.  Read more...

Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.  Read more...

In this article we'll take a look at the following Tips and Tricks for SSRS: Display Total Number of Pages while Navigating, Display Everything in a Single Page, Display Report Parameter Selection, Display No Rows Error Message, Page Settings for Optimal Printing.  Read more...

Renaming and/or moving a large number or SSRS reports through the Report Manager interface is not a trivial task. This article will demonstrate how to achieve this by writing a small console application that will make web services calls to the Reporting Services Web Service.  Read more...

The report function, lookup, can be used to link two independent datesets.  Read more...

Looking for a way to put images on SSRS reports and allow the business users to change the images every so often? This article explains how to implement this in such a way that you don't have to modify a report when the image is changed.   Read more...

What is SQL Server Reporting Services 2012 (SSRS) ReportItems collection and how do I use it? Are there any restrictions on its use? Check out this tip to learn more.  Read more...

How to get an SSRS user's AD group membership in order to filter report content  Read more...

Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.  Read more...

In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.  Read more...

Once you've prepared an SSRS report, it needs formatting to get it ready for the people who need to read it. This tip covers the basics of formatting SSRS Reports.  Read more...

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...

This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.  Read more...

This article walks through a sample dashboard, highlighting sparklines, databars, and indicators.  Read more...

This article shows how to group information, adjust for dynamic column and row groups, and generally use the tablix in Reporting Services.  Read more...