Showing posts with label matrix. Show all posts
Showing posts with label matrix. Show all posts

Friday, March 9, 2012

How to Limit the number of columns in the Matrix ?

HI all !

I am having a bit of a problem trying to limit a number of columns in a matrix appearing on a page.

At the moment, I have a dataset that lists the month and the mail packages that were sent during the month
The matrix works great HOWEVER, if there were more than 8 months in the matrix columns, it does not break and would make the page look like a huge landscape page.

I am trying to limit the number of columns appearing (this is the months column) on the matrix so that the pages stay in a potrait position. IE: every 8 columns appear on one page. Is there an option or an expression I could use in the Matrix ?
Thanks!

BErnard Ong

An update on this situation.

After figuring what keywords to use, I think I might have found the answer to this dilemma.

This is the post that might be useful to anyone who might want to wrap the number of columns in the matrix so that it will print a new page !

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=934445&SiteID=1

Can anyone suggest what would be a better way to title my thread so that other users can find this easily if they have this problem ? never thought of using the wrap keyword, and I actually had to find this thread by using "Columns in Matrix" and searching through a couple of pages.

Thanks !

Bernard Ong

Friday, February 24, 2012

How to know the rows count of a Field

I use a matrix which datasource is come from a olap
How can I know the rows count of a Field?Hi,
you can use the CountRows function. You can find more information about this
function at BOL.
Bye!
"ad" wrote:
> I use a matrix which datasource is come from a olap
> How can I know the rows count of a Field?
>
>|||Thanks,
I have tried, but I found that CountRows can only count f group members
which contain itself,
But if I want to know the count of group members of another(Say I want to
know the rows count of a column group in a row group),
how can I do that?
"Javier Catala" <JavierCatala@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:74E94833-7F46-4D5C-882D-02754D9715FA@.microsoft.com...
> Hi,
> you can use the CountRows function. You can find more information about
this
> function at BOL.
> Bye!
> "ad" wrote:
> > I use a matrix which datasource is come from a olap
> > How can I know the rows count of a Field?
> >
> >
> >