Groups | Blog | Home
all groups > sql server reporting services > may 2005 >

sql server reporting services : Variances in a matrix?


Becker
5/5/2005 12:16:02 PM
Is there anyway to show a column of variances between the columns in a
matrix? The report I'm thinking is like this:

Q1 Var Q2 Var Q3 Var Q4 Var
Sales 10 - 20 100% 15 -25% 20 33%

Becker
5/6/2005 4:47:02 AM
Thanks Wayne, I do see that example, but what I'm not sure of is what that
expression would look like? Do I use some sort of "runningvalue" sum or is
there another function I would look at to reference values of previous column
& current column?

Thanks.

[quoted text, click to view]
Wayne Snyder
5/6/2005 7:13:57 AM
If you set up the matrix to use static columns, you could simply write the
variance expression using the textbox values. There is an example of static
matrix columns on www.msbicentral.com in the downloads reportinservices rdl
section... Search for Matrix.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

AddThis Social Bookmark Button