Friday, March 9, 2012

Matrix and Jump to Report

Hello,
i create a matrix with this layout
A Students B Students C Students (...) Total
Teacher A 2 6 4 12
Teacher B 4 3 5 12
Teacher C 1 3 8 12
(...)
each count has a link to another report who shows the students width the
specific grade. How i do to make subtotal jump to another report ? Or how i
disable the hiperlink on subtotal ?
regards
--
[... JFR .. ]Assuming the column grouping is called "StudentsGroup" and the row grouping
is called "TeacherGroup", you can use an expression in the textbox action of
the cell:
=iif( InScope("TeacherGroup"), iif(InScope("StudentsGroup"), "... your
existing hyperlink ...", "... hyperlink for the student subtotal cell ..."),
"... hyperlink for teacher subtotal cell ...")
If you don't want a hyperlink to be shown, use the keyword Nothing instead
of the hyperlink string. The MSDN documentation on the functions above can
be found here:
* IIF: http://msdn.microsoft.com/library/en-us/vblr7/html/vafctiif.asp
* InScope:
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.
"JFR" <JFR@.discussions.microsoft.com> wrote in message
news:DD290BA9-ECB5-442F-B30F-CF69865D20F3@.microsoft.com...
> Hello,
> i create a matrix with this layout
> A Students B Students C Students (...) Total
> Teacher A 2 6 4 12
> Teacher B 4 3 5 12
> Teacher C 1 3 8 12
> (...)
> each count has a link to another report who shows the students width the
> specific grade. How i do to make subtotal jump to another report ? Or how
i
> disable the hiperlink on subtotal ?
> regards
> --
> [... JFR .. ]|||Thanks, it works just fine.
"Robert Bruckner [MSFT]" wrote:
> Assuming the column grouping is called "StudentsGroup" and the row grouping
> is called "TeacherGroup", you can use an expression in the textbox action of
> the cell:
> =iif( InScope("TeacherGroup"), iif(InScope("StudentsGroup"), "... your
> existing hyperlink ...", "... hyperlink for the student subtotal cell ..."),
> "... hyperlink for teacher subtotal cell ...")
> If you don't want a hyperlink to be shown, use the keyword Nothing instead
> of the hyperlink string. The MSDN documentation on the functions above can
> be found here:
> * IIF: http://msdn.microsoft.com/library/en-us/vblr7/html/vafctiif.asp
> * InScope:
> 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.
>
> "JFR" <JFR@.discussions.microsoft.com> wrote in message
> news:DD290BA9-ECB5-442F-B30F-CF69865D20F3@.microsoft.com...
> > Hello,
> >
> > i create a matrix with this layout
> >
> > A Students B Students C Students (...) Total
> > Teacher A 2 6 4 12
> > Teacher B 4 3 5 12
> > Teacher C 1 3 8 12
> > (...)
> >
> > each count has a link to another report who shows the students width the
> > specific grade. How i do to make subtotal jump to another report ? Or how
> i
> > disable the hiperlink on subtotal ?
> >
> > regards
> >
> > --
> > [... JFR .. ]
>
>

No comments:

Post a Comment