Post reply

Matrix month columns out of sequence

  • November 2, 2007 at 3:33 am

    #376625

    Hi,

    I've got a matrix that runs for a date range, say 1/11/2006 to 1/11/2007 and has culmns per month but not all rows have data for each month. Because the 1st row of data only has data for say Apr, Jun, Oct it outputs these months 1st ? Is there a way I can get the columns to appear in a fixed order ?

    thanks

    Steve

  • November 2, 2007 at 6:39 am

    #747717

    Can you describe this in more detail? I can't see the problem.

  • November 2, 2007 at 7:41 am

    #747740

    sure, if i have 2 rows of data where row 1 contains data for May, Aug, Oct and row 2 has data for Jun, Jul and Oct I'm getting the columns order as May, Aug, Oct, Jun, Jul

  • November 2, 2007 at 8:32 am

    #747773

    You should really post some DDL and sample data along with exactly what the output should look like. Once you do that you'll have about a zillion people on this forum who will give you more answers you can handle (sic).

  • November 2, 2007 at 6:43 pm

    #747952

    Steve,

    You need to indicate an explicit sort for the matrix column headers. Otherwise, in my experience they simply are displayed in the order the data is returned from the underlying dataset.

    To set the sort, right-click on the matrix column header (month), select "Edit Group", and go to the Sorting tab. You will need a field or expression that you can properly sort by, for example the year and month numbers of your date.

    Hope this helps,

    Scott

  • November 5, 2007 at 2:06 am

    #748128

    Perfect Scott, that worked a treat, thanks !

    Michael, your point about posting code has been duly noted, thanks for input.

  • November 5, 2007 at 2:15 am

    #748132

    So I ask the forum, has anyone understood Steve's problem - much less Scott's solution?

    Having 'duly noted' my comment about posting code sounds like you're a bit ticked off with me. I'm truly sorry about that.

  • November 5, 2007 at 2:20 am

    #748133

    No, not at all Michael, i really do thank you for your input, i'm always very grateful for anybody who puts time into forums to try and help me out.

    i'm never sure how much or what to put into forum questions when i ask, i always try to be as generic as possible and not so specific to my databases or queries, but i can see from you post, unless i miss read it that maybe posting the actual code will be more helpful.

    Steve

  • November 5, 2007 at 2:37 am

    #748139

    I just realized that the full title is "Matrix month columns out of sequence in 'Reporting Services'". The 'Reporting Services' part doesn't show up in the browser. I caught it just now in the subject of the email.

    So that clears up my misunderstanding of 'where' this problem is coming from.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply