in

jetlounge

the minty fresh blog that whitens your teeth!

Custom Totals in Reporting Services Matrix Reports

by David Leibowitz | December 11, 2007 | Comments: 0

I've got an article titled "Advanced Matrix Reporting" over at Simple-Talk that was just published.

The biggest issue I find with the Matrix control in SSRS is the difficulty in doing complex aggregates other than SUM. Sometimes you'd like to do variances of year over year totals. Check out the article for dynamic dataset creation, query based grouping, dynamic column names, cells-in-cells technique, custom matrix aggregates using InScope() and custom chart coloring.

Check it out here:

http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/

del.ico.us digg this technorati BlinkList Furl reddit DotNetKicks google! live Facebook Stumble Upon Yahoo!



Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
Powered by Community Server (Non-Commercial Edition), by Telligent Systems