Posted - 09/14/2012 : 05:06:39
I have a matrix displaying the following information (this is what is returned from the SPROC):
I need it to be displayed like this:
The user chooses a time period (eg. January - February/March - August...any combination) and a teacher(s), then the number of lessons each teacher completed in each month in the chosen time period is returned. I'm using a matrix as the number of columns displayed is dynamic each time. I have a column group for the lesson month column in my matrix, and I right-clicked on the header cell and chose 'Subtotal'. I saw the total column appear at the end of the rows, great. Here's my matrix in design mode:
However, when I Preview the report, the value in the Total column is just the value for the first month, eg. 32 and 0 in the above example. Any ideas why this is happening?
Here's what the matrix looks at run time, when I preview the report:
The text in the header cell for each month column is based on an expression, as I want the name of the month to appear. Maybe the fact that the cell I'm clicking on to get the subtotal has an expression is having some effect?
Here's the expression:
I've been searching & searching for an answer for this, and trying all sorts of things. Any help would be great, thanks!