Prev: Stored Procedure
Next: Initial Toggle State
From: Shaf on 12 Mar 2010 21:49
Good Evening All,

Using SSRS 2008 and Report Builder…

I have a recordset of financial transaction over the last two years
(2010, 2009) that I am presenting in a tablix.

The tablix has a “row group” where I am grouping on product type, and
a “column group” that I am grouping on year(transaction date).

So when I expand the report, the resulting report looks something like
this:

Product +2010 +2009
Item 1 $10000 $8000
Item 2 $5000 $4000
Item 3 $30000 $25000

So now what I need is to do a variance between the two years, but for
the life of me I can’t figure out the right expression to dynamically
pull in the column group amounts so I can do some math on them.

Thoughts?

Thanks,

Steve


 | 
Pages: 1
Prev: Stored Procedure
Next: Initial Toggle State