July 16, 2008 at 3:00 pm
i want a value from the detail section to be shown on the page footer.
Detail section is divided into two matrix with two dataset.
How do i do it with a variable.
July 17, 2008 at 1:24 am
Hi
The difficulty with a matrix is knowing which value you want shown on the page footer, the problem is that one detail cell of course holds many different values according to the number of columns and rows that are printed on the matrix.
If you wanted to show the grand total then you could name the grand total cell (for example GrandTotal) and then refer to this in a text box in the footer area by using the expression =ReportItems!GrandTotal.Value
If you were looking for the maximum or average value of the detail cells then this "might" be possible by naming the cell (for example DetailCell) and then using an expression such as =MAX(ReportItems!DetailCell.Value) in the footer area. Please note that this is a bit of a guess as I've not tried to do this.
I am sure there is a way through custom code to build an array of values for other cells, but I have no idea how to do this.
Which value were you looking for?
Regards,
Nigel West
UK
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply