Post reply

Graph Sort Order

  • February 22, 2012 at 5:32 am

    #265033

    Hey guys, I am getting an ordered data set e.g User, loginCount. I put this into a tablix and a graph, the tablix orders them correctly, the graph orders them randomly.

    How do I order the graph by what is returned?

    thanks guys

    Ian Cockcroft
    MCITP BI Specialist

  • February 22, 2012 at 7:28 am

    #1450273

    Hi

    Have you tried putting an ORDER BY in the query?

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • February 22, 2012 at 7:55 am

    #1450307

    HI Andy, its pulling from a stored proc, the Order by is in the sp.

    Ian Cockcroft
    MCITP BI Specialist

  • February 22, 2012 at 8:06 am

    #1450320

    Your User field I'm making the assumption that its a string data type and is a name that you need to order A - Z (or Z - A) and not a random user ID?

    An afterthought - your Order By is on the User column and not some other column in the sproc?

    And another afterthought! - If you right click on the data that contains the values for your user on the Axis (the region of the chart where you drag your column onto the graph) and go to Category Group Properties > Sorting is there anything specified? If so you can change the sort order on the chart here by selecting User

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Viewing 4 posts - 1 through 3 (of 3 total)

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