In this article, Koen Verbeeck illustrates how to add a linear trendline to a graph in SSRS, similar to the way it would appear if done Excel.  Read more...

Use custom assemblies to generate a heat map matrix in SQL Server Reporting Services  Read more...

In order to analyze the data in a line chart better, we want to add trendlines to the graph, such as a weighted average. Here's how to add a "calculated series" to a line chart easily in SQL Server Reporting Services.  Read more...

SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?  Read more...

Kathi Kellenberger demonstrates how to start adding visual flair to your SSRS reports, using its impressive set of visual controls, ranging from basic charts to gauges, indicators, sparklines, and maps.  Read more...

You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.  Read more...

Learn how to invoke SSRS reports from an SSIS package after the data load is completed.  Read more...

In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.  Read more...

You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.  Read more...

This article demonstrates the use of custom code and cell expressions referencing that custom code to toggle the background color of groups of rows in an SSRS report based upon value-changes in one of the fields.  Read more...

When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.  Read more...

Your SQL Server Report Server service will not start or you keep getting an error when you navigate to the SSRS URL? What logging tools are available to assist you with diagnosing SSRS problems, issues, or errors? Check out this tip to learn more.  Read more...

In this chapter, we will learn how to create Data Mining Reports using Reporting Services.  Read more...

While the Reporting Wizard and basic report tables will do for prototyping, very soon we'll want to add some finesse to our reports, and allow our report users to create different views of the same data, dynamically. Kathi Kellenberger shows us how it's done.  Read more...

Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.  Read more...

After a period of abstinence, Rodney Landrum adjusts to life back in the USSRS.  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...

Should you be using Report Builder 3.0 or SQL Server Reporting Services 2008 R2 to build reports? Here's the 411!  Read more...

Kathi Kellenberger describes the basics of SSRS before showing you how to build quick, simple reports.  Read more...

I want to embed code into my SQL Server Reporting Servers (SSRS) to allow special formatting for report output. How do I implement and deploy this code and what functionality can use this embedded code?  Read more...