You have a reporting requirement where a user has two or more parameters for a single report, but the values for one parameter depend on the values chosen in a previous parameter. Ghanesh Prasad explains how to create cascaded parameters in SQL Server Reporting Services to solve this issue.  Read more...

SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.  Read more...

Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates how to configure reports for native-mode deployment using Report Manager, and then deploy them from within SSDT-BI. She also explains how to use the Report Builder to provide "self-service" reporting to end users, allowing them to build custom reports based on report parts and shared datasets.  Read more...

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...