hiding link condtionally

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.
"teko" <anonymous@.discussions.microsoft.com> wrote in message
news:0abc01c498cf$589e5440$a301280a@.phx.gbl...
> 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.
>|||>--Original Message--
>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.
>
>"teko" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0abc01c498cf$589e5440$a301280a@.phx.gbl...
>> 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.
>
>.
>many thanks..it works