Help with matrix report.

Hi All,

I have the following matrix report.

Health 1 2 3 4 Std: 1 Health Promotion and Disease Prevention 4 2 4 3 Std: 2 Accessing Health Information, Products, and Services 2 2 Std: 3 Self-Management 2 Std: 4 Influence of Culture, Media, and Technology 2 2 Std: 5 Interpersonal Communication 3 Std: 6 Goal Setting and Decision Making Skills 4 2 Std: 7 Advocating for Health 3

I need a bit of help to do two things.

One is the first row needs to be the average of the matrix columns (1,2,3,4).

Two is for a header row that will span the matrix columns.

So the final output would be;

Average Proficiency Level Health 1 2 3 4 Overall 2.8 2.3 3 2.5 Std: 1 Health Promotion and Disease Prevention 4 2 4 3 Std: 2 Accessing Health Information, Products, and Services 2 2 Std: 3 Self-Management 2 Std: 4 Influence of Culture, Media, and Technology 2 2 Std: 5 Interpersonal Communication 3 Std: 6 Goal Setting and Decision Making Skills 4 2 Std: 7 Advocating for Health 3

The number of columns can vary from 1 to 4.

Any help would be very much appreciated.

For the header, you can put a fixed-width table above the report.

Another is here..

http://blogs.msdn.com/bwelcker/archive/2005/05/11/416720.aspx

For the average, did you try looking at the AVG() function?

cheers,

Andrew|||

Andrew,

The header worked great. I have looked at the AVG() function, but how can I make it the first row in the column?

When I try I get "A group expression for the matrix includes an aggregate function. Aggregate functions can not be used in group expressions."