Conditional Formatting with switch
up vote
0
down vote
favorite
This is the design view of my matrix, it uses a series of datasets and the expressions use a lookup
This is the report when it has ran. I want to add some conditional formatting to the end column
The conditional formatting is dependent on the name of the person and then what total is in that field. Below is what I have tried. I would expect only Hilary's cell to show a colour. However others are appearing as green.
=switch(Fields!Name.value = "Hilary" and
reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
ssrs-2012 reportbuilder3.0 report-builder2.0
asked Nov 22 at 12:49
whitz11
7513
add a comment |
up vote
0
down vote
favorite
This is the design view of my matrix, it uses a series of datasets and the expressions use a lookup
This is the report when it has ran. I want to add some conditional formatting to the end column
The conditional formatting is dependent on the name of the person and then what total is in that field. Below is what I have tried. I would expect only Hilary's cell to show a colour. However others are appearing as green.
=switch(Fields!Name.value = "Hilary" and
reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
ssrs-2012 reportbuilder3.0 report-builder2.0
asked Nov 22 at 12:49
whitz11
7513
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
This is the design view of my matrix, it uses a series of datasets and the expressions use a lookup
This is the report when it has ran. I want to add some conditional formatting to the end column
The conditional formatting is dependent on the name of the person and then what total is in that field. Below is what I have tried. I would expect only Hilary's cell to show a colour. However others are appearing as green.
=switch(Fields!Name.value = "Hilary" and
reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
ssrs-2012 reportbuilder3.0 report-builder2.0
asked Nov 22 at 12:49
whitz11
7513
This is the design view of my matrix, it uses a series of datasets and the expressions use a lookup
This is the report when it has ran. I want to add some conditional formatting to the end column
The conditional formatting is dependent on the name of the person and then what total is in that field. Below is what I have tried. I would expect only Hilary's cell to show a colour. However others are appearing as green.
=switch(Fields!Name.value = "Hilary" and
reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
ssrs-2012 reportbuilder3.0 report-builder2.0
ssrs-2012 reportbuilder3.0 report-builder2.0
asked Nov 22 at 12:49
whitz11
7513
asked Nov 22 at 12:49
whitz11
7513
asked Nov 22 at 12:49
whitz11
7513
asked Nov 22 at 12:49
whitz11
7513
asked Nov 22 at 12:49
whitz11
7513
7513
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
If I understood correctly, all other names should get the cell with a blank background, shouldn't they ?
In this case, you have to add the condition "Name=Hilary" for each row. In your expression, this one is just related to the first row.
Try this one:
=switch(
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
answered Nov 22 at 13:15
NickNick
1548
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 at 13:24
keep in mind that your expression will change the background color only if the value is between 0 and 100. You're not taking account negative value or value higher than 100
– NickNick
Nov 22 at 13:26
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
If I understood correctly, all other names should get the cell with a blank background, shouldn't they ?
In this case, you have to add the condition "Name=Hilary" for each row. In your expression, this one is just related to the first row.
Try this one:
=switch(
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
answered Nov 22 at 13:15
NickNick
1548
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 at 13:24
keep in mind that your expression will change the background color only if the value is between 0 and 100. You're not taking account negative value or value higher than 100
– NickNick
Nov 22 at 13:26
add a comment |
up vote
1
down vote
accepted
If I understood correctly, all other names should get the cell with a blank background, shouldn't they ?
In this case, you have to add the condition "Name=Hilary" for each row. In your expression, this one is just related to the first row.
Try this one:
=switch(
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
answered Nov 22 at 13:15
NickNick
1548
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 at 13:24
keep in mind that your expression will change the background color only if the value is between 0 and 100. You're not taking account negative value or value higher than 100
– NickNick
Nov 22 at 13:26
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
If I understood correctly, all other names should get the cell with a blank background, shouldn't they ?
In this case, you have to add the condition "Name=Hilary" for each row. In your expression, this one is just related to the first row.
Try this one:
=switch(
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
answered Nov 22 at 13:15
NickNick
1548
If I understood correctly, all other names should get the cell with a blank background, shouldn't they ?
In this case, you have to add the condition "Name=Hilary" for each row. In your expression, this one is just related to the first row.
Try this one:
=switch(
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=0 and reportitems!Textbox62.value <= 9,"#fd6767",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >=10 and reportitems!Textbox62.value <=19, "#f8d3a9",
Fields!Name.value = "Hilary" and reportitems!Textbox62.value >= 20 and reportitems!Textbox62.value <=100,"LightGreen")
answered Nov 22 at 13:15
NickNick
1548
answered Nov 22 at 13:15
NickNick
1548
answered Nov 22 at 13:15
NickNick
1548
answered Nov 22 at 13:15
NickNick
1548
1548
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 at 13:24
keep in mind that your expression will change the background color only if the value is between 0 and 100. You're not taking account negative value or value higher than 100
– NickNick
Nov 22 at 13:26
add a comment |
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 at 13:24
keep in mind that your expression will change the background color only if the value is between 0 and 100. You're not taking account negative value or value higher than 100
– NickNick
Nov 22 at 13:26
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 at 13:24
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 at 13:24
keep in mind that your expression will change the background color only if the value is between 0 and 100. You're not taking account negative value or value higher than 100
– NickNick
Nov 22 at 13:26
keep in mind that your expression will change the background color only if the value is between 0 and 100. You're not taking account negative value or value higher than 100
– NickNick
Nov 22 at 13:26
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431431%2fconditional-formatting-with-switch%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
