matrix column aggregations

Quick question for you pro's...

Within a report matrix, I want to be able to have different aggregations for totals. One column would be a Sum of the data in that column, the next column would be an Average of the data. Is this possible, or is this not supported in SSR2005?

Thanks in advance for your help,

Clint

Hello xtrout,

It is possible. What u have to do is - use a rectangle control, which will work as a container. Now u can place as many textboxes in it as u want. Where each text box is having a different aggregate function. If u r intended to display the aggregation only in subtotal column not at detail level then u can put the following expression for the 'visibility' property of the desired control (i.e. the textbox which u don't want to display in the detail section)

=iif(InScope("ColCountry"), true, false)

Here 'ColCountry' is the column group name in my case

I think this will solve ur problem

|||

Thanks for the info. It is close, but still does not seem to work properly. Using the rectangle with with your provided expression puts the two different aggregates into the same column so there is two columns nested in one. Do you know how to separate them? Maybe I need to do a tabular report instead of the matrix.

Thanks,

Clint

|||

Sorry xtrout,

I don't know any other alternative in matrix control. But I am using it this way by giving different column headers within a single column.

|||Thanks for the suggestion. It was worth a shot.