Post reply

SSRS chart issue

  • August 22, 2012 at 9:47 am

    #393002

    Hi

    I am retrieving just MonthYear, TotalSales from the query.

    I want to show MonthYear on X-axis and TotalSales on Y-axis. I dragged the columns(MonthYear in CategoryGroup and TotalSales in values). This is fine showing the chart.

    But I want MonthYear to be sorted. Even though the data is sorted in the query, chart displays in different order.

    Ex: MonthYear = January 2009, February 2009 bla bla.

  • August 22, 2012 at 9:53 am

    #1528755

    a2zwd (8/22/2012)

    Hi

    I am retrieving just MonthYear, TotalSales from the query.

    I want to show MonthYear on X-axis and TotalSales on Y-axis. I dragged the columns(MonthYear in CategoryGroup and TotalSales in values). This is fine showing the chart.

    But I want MonthYear to be sorted. Even though the data is sorted in the query, chart displays in different order.

    Ex: MonthYear = January 2009, February 2009 bla bla.

    Edit the properties of MonthYear in the chart, and change the sorting to sort by some integer that's part of the query.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • August 22, 2012 at 10:03 am

    #1528763

    Hi

    Thanks for the reply. I resolved it. It is just a caching problem.

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

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