Browse by Tags

All Tags » reporting services (RSS)

Guide for new Report Builder users

"They'll probably still just ask me for their reports..." I hear students say when I teach them about Report Builder in SQL Server 2005 Reporting Services (SSRS). It's a reasonable fear. Their managers have always asked them for reports...
Posted by Rob Farley | with no comments
Filed under:

How multi-value query parameters in SSRS are treated by SQL Server

This is something that has bothered for me for a while. In SQL Server Reporting Services, you write a query against a data source, and that becomes the data set for the report. Brilliant. I like to write the query in Management Studio first, and then...
Posted by Rob Farley | 4 comment(s)
Filed under: ,

How to format the subtotals of a Reporting Services matrix differently, using InScope

Here's the scenario. Your SQL Server Reporting Services (SSRS) report has a matrix, showing the sales of each salesperson per year. You put conditional formatting in place so that cells in the matrix that have sales over 1000000 are in a different...
Posted by Rob Farley | 9 comment(s)
Filed under: ,