hi all
i have a matrix report (rows&cols)and both are grouped
and the subtotal is displayed at the end of the
matrix,the problem is that i am making a jump link for
each data cell of the matrix and i dont want any links
for the totals cells(the ones on the edges of the matrix)
is there any expression to do this(hide links when the
cell is at totals(Hor,Ver)),please advize.

Assuming the matrix column group has the name "ColumnGroup" and the matrix
row group has the name "RowGroup", you would use an expression like this on
the cell's hyperlink:
=iif(InScope("ColumnGroup") AND InScope("RowGroup"), "http:// some link",
Nothing)

A subtotal is not calculated in the scope of it's grouping, therefore
InScope will return false for subtotal cells for a certain grouping.

More information on the InScope function is available in BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_0jmt.asp

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

[quoted text, click to view]
url=/library/en-
us/rscreate/htm/rcr_creating_expressions_v1_0jmt.asp
[quoted text, click to view]