Monday, March 19, 2012

Matrix question

I have a matrix issue with the colum ordering. What I want is for the
month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I
cannot determine how to order them correctly. can someone point me in the
right direction?Brian,
In a matrix you probably have the month set up as a group. In the properties
of this group there is a sorting tap, I dont have a full picture of how you
set things up but I think choosing it to order by MonthNr should be the
thing to do.
regards
Perry
"Brian L" <BrianL@.discussions.microsoft.com> wrote in message
news:FF93F19C-A0A4-4BF6-98B9-482B0396F37C@.microsoft.com...
>I have a matrix issue with the colum ordering. What I want is for the
> month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I
> cannot determine how to order them correctly. can someone point me in the
> right direction?|||thanks perry, i noticed that too. Problem is I want to arrange the columns
horizontally, not the values vertically. I'm still searching technet and BOL
for an answer. Thanks again.
"Perry" wrote:
> Brian,
> In a matrix you probably have the month set up as a group. In the properties
> of this group there is a sorting tap, I dont have a full picture of how you
> set things up but I think choosing it to order by MonthNr should be the
> thing to do.
> regards
> Perry
>
> "Brian L" <BrianL@.discussions.microsoft.com> wrote in message
> news:FF93F19C-A0A4-4BF6-98B9-482B0396F37C@.microsoft.com...
> >I have a matrix issue with the colum ordering. What I want is for the
> > month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I
> > cannot determine how to order them correctly. can someone point me in the
> > right direction?
>
>|||Perry - Ignore my last post. What I wrote didn't make sense. You were on the
money. Question is, how do you write the expression to hard code the sort?
Guess I'll keep reading. Thanks.
"Perry" wrote:
> Brian,
> In a matrix you probably have the month set up as a group. In the properties
> of this group there is a sorting tap, I dont have a full picture of how you
> set things up but I think choosing it to order by MonthNr should be the
> thing to do.
> regards
> Perry
>
> "Brian L" <BrianL@.discussions.microsoft.com> wrote in message
> news:FF93F19C-A0A4-4BF6-98B9-482B0396F37C@.microsoft.com...
> >I have a matrix issue with the colum ordering. What I want is for the
> > month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I
> > cannot determine how to order them correctly. can someone point me in the
> > right direction?
>
>|||Brian,
in reply to -- how do you write the expression to hard code the sort?
(I have 7 months working experience with RS2000 and RS2005, I am guessing we
are/were both confronted with the same issues to solve one way or the other,
you can decide if this means enough about knowledge :-) )
To my knowledge you can not hardcode into the group expression itself how to
sort anything (i never to that there). This can only be done in the sorting
tab, for me this does the trick in all cases.
Sometimes I may use something like fiscalyear, left(fiscalmonthname,3) in
the columns. In my query I also select the fiscalmonthnr. In the matrix I
choose to show the fiscalyear, fiscalmonthname (first 3 characters, this you
can solve either in de query, or in the report). The fiscalmonthname I sort
on the fiscalmonthnr ascending, which is selected in the dataset but not
shown in the report (just for sorting purposes).
If this reply misses your point (then i misunderstood something), then which
expression you mean and where do you set it?
Perry
"Brian L" <BrianL@.discussions.microsoft.com> wrote in message
news:5ABD05FF-2F13-4F0B-A5EC-18C949D0A915@.microsoft.com...
> Perry - Ignore my last post. What I wrote didn't make sense. You were on
> the
> money. Question is, how do you write the expression to hard code the sort?
> Guess I'll keep reading. Thanks.
> "Perry" wrote:
>> Brian,
>> In a matrix you probably have the month set up as a group. In the
>> properties
>> of this group there is a sorting tap, I dont have a full picture of how
>> you
>> set things up but I think choosing it to order by MonthNr should be the
>> thing to do.
>> regards
>> Perry
>>
>> "Brian L" <BrianL@.discussions.microsoft.com> wrote in message
>> news:FF93F19C-A0A4-4BF6-98B9-482B0396F37C@.microsoft.com...
>> >I have a matrix issue with the colum ordering. What I want is for the
>> > month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I
>> > cannot determine how to order them correctly. can someone point me in
>> > the
>> > right direction?
>>|||Thanks Perry.
"Perry" wrote:
> Brian,
> in reply to -- how do you write the expression to hard code the sort?
> (I have 7 months working experience with RS2000 and RS2005, I am guessing we
> are/were both confronted with the same issues to solve one way or the other,
> you can decide if this means enough about knowledge :-) )
> To my knowledge you can not hardcode into the group expression itself how to
> sort anything (i never to that there). This can only be done in the sorting
> tab, for me this does the trick in all cases.
> Sometimes I may use something like fiscalyear, left(fiscalmonthname,3) in
> the columns. In my query I also select the fiscalmonthnr. In the matrix I
> choose to show the fiscalyear, fiscalmonthname (first 3 characters, this you
> can solve either in de query, or in the report). The fiscalmonthname I sort
> on the fiscalmonthnr ascending, which is selected in the dataset but not
> shown in the report (just for sorting purposes).
> If this reply misses your point (then i misunderstood something), then which
> expression you mean and where do you set it?
> Perry
>
> "Brian L" <BrianL@.discussions.microsoft.com> wrote in message
> news:5ABD05FF-2F13-4F0B-A5EC-18C949D0A915@.microsoft.com...
> > Perry - Ignore my last post. What I wrote didn't make sense. You were on
> > the
> > money. Question is, how do you write the expression to hard code the sort?
> > Guess I'll keep reading. Thanks.
> >
> > "Perry" wrote:
> >
> >> Brian,
> >>
> >> In a matrix you probably have the month set up as a group. In the
> >> properties
> >> of this group there is a sorting tap, I dont have a full picture of how
> >> you
> >> set things up but I think choosing it to order by MonthNr should be the
> >> thing to do.
> >>
> >> regards
> >>
> >> Perry
> >>
> >>
> >> "Brian L" <BrianL@.discussions.microsoft.com> wrote in message
> >> news:FF93F19C-A0A4-4BF6-98B9-482B0396F37C@.microsoft.com...
> >> >I have a matrix issue with the colum ordering. What I want is for the
> >> > month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I
> >> > cannot determine how to order them correctly. can someone point me in
> >> > the
> >> > right direction?
> >>
> >>
> >>
>
>|||Seems like I made a simple problem into a difficult one. To fix my problem, I
added another criteria to my report. Month(Date) as MonthNum. Then used that
in the matrix and sorted ascending rather than using the month name ( Jan,
Feb. ) Worked like a charm.
"Perry" wrote:
> Brian,
> in reply to -- how do you write the expression to hard code the sort?
> (I have 7 months working experience with RS2000 and RS2005, I am guessing we
> are/were both confronted with the same issues to solve one way or the other,
> you can decide if this means enough about knowledge :-) )
> To my knowledge you can not hardcode into the group expression itself how to
> sort anything (i never to that there). This can only be done in the sorting
> tab, for me this does the trick in all cases.
> Sometimes I may use something like fiscalyear, left(fiscalmonthname,3) in
> the columns. In my query I also select the fiscalmonthnr. In the matrix I
> choose to show the fiscalyear, fiscalmonthname (first 3 characters, this you
> can solve either in de query, or in the report). The fiscalmonthname I sort
> on the fiscalmonthnr ascending, which is selected in the dataset but not
> shown in the report (just for sorting purposes).
> If this reply misses your point (then i misunderstood something), then which
> expression you mean and where do you set it?
> Perry
>
> "Brian L" <BrianL@.discussions.microsoft.com> wrote in message
> news:5ABD05FF-2F13-4F0B-A5EC-18C949D0A915@.microsoft.com...
> > Perry - Ignore my last post. What I wrote didn't make sense. You were on
> > the
> > money. Question is, how do you write the expression to hard code the sort?
> > Guess I'll keep reading. Thanks.
> >
> > "Perry" wrote:
> >
> >> Brian,
> >>
> >> In a matrix you probably have the month set up as a group. In the
> >> properties
> >> of this group there is a sorting tap, I dont have a full picture of how
> >> you
> >> set things up but I think choosing it to order by MonthNr should be the
> >> thing to do.
> >>
> >> regards
> >>
> >> Perry
> >>
> >>
> >> "Brian L" <BrianL@.discussions.microsoft.com> wrote in message
> >> news:FF93F19C-A0A4-4BF6-98B9-482B0396F37C@.microsoft.com...
> >> >I have a matrix issue with the colum ordering. What I want is for the
> >> > month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I
> >> > cannot determine how to order them correctly. can someone point me in
> >> > the
> >> > right direction?
> >>
> >>
> >>
>
>

No comments:

Post a Comment