Matrix Queries

I've just started using report martix's (RS2005) and have a couple of
questions.
Is it possible to change the way a summary for a column calculates. By
default it does a sum but on a certain row I want an average. can this been
done or am I stuck with a sum.
Also i would like to be able to have a static heading right at the top of
the matrix, at the moment i'm using the top left cell but this isn't ideal
--
Cheers
Luke
http://beakersoft.blogspot.comOfcourse you can use "Average", Give a title which is not changing, I mean
different values. then it will display single value. If you want the title to
be same then might as well you can think of table instead of matrix.
Amarnath, MCTS.
"lukethepunk" wrote:
> I've just started using report martix's (RS2005) and have a couple of
> questions.
> Is it possible to change the way a summary for a column calculates. By
> default it does a sum but on a certain row I want an average. can this been
> done or am I stuck with a sum.
> Also i would like to be able to have a static heading right at the top of
> the matrix, at the moment i'm using the top left cell but this isn't ideal
> --
> Cheers
> Luke
> http://beakersoft.blogspot.com