Browse by Tags

All Tags » reporting services (RSS)
Mon, Dec 21 2009 20:18

Infinite Drill-through in a single SSRS report

Grant Paisley of Angry Koala and Report Surfer put me onto this a while back, and I have to admit I’m a bit of a fan. The idea comes from the fact the way that SQL Server Reporting Services (both 2005 and 2008) handles parameters with Analysis Services...
Posted by Rob Farley | with no comments
Filed under: , , , ,
Wed, Aug 5 2009 0:22

SSRS: Removing the Navigation link using an Expression

There are times when you want to have a Navigation property of a textbox (typically providing a link to a URL or other report), but you don’t always want the link to be there. Sometimes you just want it to be an ordinary textbox. This particularly applies...
Posted by Rob Farley | with no comments
Filed under: ,
Sat, Jul 25 2009 23:19

A review: "Learning SQL Server 2008 Reporting Services” by Jayaram Krishnaswamy

A while back I got asked if I’d review this book, but as they could only get me a copy in PDF format, it’s taken a while to get to it. Whilst I like having electronic copies of books, I generally prefer to read them in paper form, and just have the electronic...
Posted by Rob Farley | 4 comment(s)
Filed under: ,
Fri, Dec 14 2007 18:42

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:
Fri, Nov 23 2007 8:48

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: ,
Thu, Nov 22 2007 12:54

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 | 32 comment(s)
Filed under: ,