Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Display monday always on x-axis SSRS

Answered Display monday always on x-axis SSRS

  • Wednesday, March 06, 2013 12:38 PM
     
     
    Sign In to Vote
    0

    Hi Friends,

    I want to display only Mondays on the X-Axis for this where I wanna set the option for this 

    Can anyone guide me please

     

All Replies

  • Wednesday, March 06, 2013 1:04 PM
     
     
    Sign In to Vote
    0

    Hi Siva,

    go to your Chart -> Click on Chart you will get a window having  'Values, Category Groups, Series Grousp'

    Go to Category Groups->

    Right Click on Category Field -->

    Select Category Group Properties ->

    Go to Filters tab ->

    and then Add Expression as per your requirement to select only MONDAYS

    Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com

     
  • Wednesday, March 06, 2013 2:00 PM
     
     
    Sign In to Vote
    0

    I don't wanna filter the data just I wanna show Mondays... If I fallow your process chart will retrieve only Mondays data should't bring other days data.

    Any other way please

     
  • Wednesday, March 06, 2013 3:55 PM
     
     
    Sign In to Vote
    0

    Hi Siva,

    It means you want to visualize all data on chart but on horizontal axis label only Mondays should be visible
    Something like below image

    If I am wrong please correct me.....

    This can be achieved by setting color expression in Horizontal axis label. Till SSRS 2008 this was not possible, but SSRS 2008 R2 onwards I am not sure since not tried. So better give a try, even i'll come back with any solution or atleast a workaround.

     

    Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com

     
  • Wednesday, March 06, 2013 4:01 PM
     
     
    Sign In to Vote
    0

    Yes your assumption is right. there is an option like Hide labels but it seems it is not working in my case.



    • Edited by BI Siva Wednesday, March 06, 2013 4:02 PM
    • Edited by BI Siva Wednesday, March 06, 2013 4:03 PM
    •  
     
  • Wednesday, March 06, 2013 5:13 PM
     
     
    Sign In to Vote
    0

    Hi Siva,

    You already asked this question on a previous post. You should provide feedback there.

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4af8175c-70c1-43fd-ba42-7954965db8e0

    Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

    k r o o t z

     
  • Thursday, March 07, 2013 8:32 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    Do you means that you want to part of the X-axis labels? If so, as per my understanding, it is not support. When we set the axis label options, we can hide the first and last or all labels along the X-axis.
    If the axis type is dates, you want specify the “interval” values of the scalar. 
    For more information, please see: How to: Specify an Axis Interval

    Regards，
    Fanny Liu

    Fanny Liu
    TechNet Community Support

     
  • Thursday, March 07, 2013 10:26 AM
     
     
    Sign In to Vote
    0

    Hi Krootz.

    I did't get the result for that also.... I have seen some where colour format is not possible on X-axis in the same way

    can't we hide rest of the Labels except Monday????