sql server reporting services: I was looking for some help with a matrix style report I am trying to
develop.

Example, months accross the top, columns would be product grouping,
then year. The detail would be a summation of invoice value. I can
achieve this no problem. The issue is when I want to get a variance
between the two years, i.e. Jan 2006 vs 2007 as row, underneath each
month.

Any help would be greatly appreciated.

Do you want to have the variance as a total for all product groups, or total
for each product group?

I think you can solve it by adding a new row group, and in your details have
a conditional statement like

=iif(InScope("matrix2_Year"),
iif(InScope("matrix2_Month"),
Fields!Measures_Invoice.Value,
SUM(CINT(Fields!Measures_Invoice.Value))),
iif(InScope("matrix2_Month"),
First(Fields!Measures_Invoice.Value, "matrix2_Month") -
Last(Fields!Measures_Invoice.Value, "matrix2_Month"),
"")
)

I usually end up with a test matrix and play around with an expression like
this:

=iif(InScope("rowgroup"),
iif(InScope("colgroup"),
a
b),
iif(InScope("colgroup"),
c,
d)
)

Also, check out where your static group end up. You find this in the Groups
view in the matrix properties. Try changing the order of the column groups
to get the view you want.

When I do funky matrixes, I usually end up spending a lot of time trying and
failing. I think what you want to do is doable, but can't give you a
definitive solution. But try playing around with the InScope function and
conditional formating and column groups and row groups and you'll get it.
With regards,
Kaisa M. Lindahl Lervik

[quoted text, click to view]