Matrix Width

Is there a way to ensure a matrix layout does not expand horizontally
past a certain point (i.e. page)? There appears to be an option to try
and fit the matrix on one page but that doesn't stop it going over
multiple pages in the horizontal direction.
ThanksOn Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
Outside of the option you mentioned, as far as I know, there is
nothing else available. Sorry I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
It will cut off additional data, but you could filter the outermost
column group on {group expression} by "Top N" ={max columns}, i.e for
at most 5 columns grouped on myID you would have a group filter for
myID by 'Top N' with value of '=5'.
Hope this helps ~ K

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 .. ]
>
>

matrix

hey there

Can anyone direct me to explicit examples of a matrix.

eg I would like to see the layout view // then preview

I am using Visual Studio.net 2003 and Reporting Services

thanks

jewel

You can install the AdventureWorks sample reports during the setup installation of Reporting Services. The "Company Sales" sample report provides a matrix layout.

You can also take a look at this article: http://www.gotreportviewer.com/matrices/index.html
While that how-to article is targeted at the ReportViewer controls shipped in VS 2005, most of it still applies for Reporting Services 2000 / Report designer in VS 2003.

Also RS Books Online contains information about matrix reports, e.g.: http://msdn2.microsoft.com/en-us/library/ms157334.aspx

-- Robert