Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Change line color?

Answered Change line color?

  • Tuesday, February 19, 2013 10:27 PM
     
     
    Sign In to Vote
    0

    I'm having trouble with an expression. I'm trying to change the color of my lines in SSRS. I really just want to make the field RunningTotalThisYr orange, RunningTotalLastYr black, and Goal red. (As a side note, I'm just using "Goal" to put a threshold line to see how close we are to meeting our goal). Here's what I've tried:

    =Switch(Fields!RunningTotalThisYr.Value > 0, "Orange", Fields!RunningTotalLastYr.Value > 0, "Black", Fields!Goal.Value > 0, "Red")

    Here is the dataset:

    Here is the result:

    Any help is appreciated :-)

     

All Replies

  • Wednesday, February 20, 2013 3:54 AM
     
     Answered
    Sign In to Vote
    1
    Where have you put the expression?  I dont think you even need an expression.  Can you just highlight each line series and change the colour in the properties window?
     
  • Wednesday, February 20, 2013 4:21 AM
     
     
    Sign In to Vote
    1

    Correct no need of expression for this because all are different measures select on the line and go to properties window and change the property "color" to required color.

    Regards,Eshwar.

    Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.