Conditional Formatting with switch
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 '18 at 12:49
whitz11whitz11
9013
add a comment |
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 '18 at 12:49
whitz11whitz11
9013
add a comment |
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 '18 at 12:49
whitz11whitz11
9013
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 '18 at 12:49
whitz11whitz11
9013
asked Nov 22 '18 at 12:49
whitz11whitz11
9013
asked Nov 22 '18 at 12:49
whitz11whitz11
9013
asked Nov 22 '18 at 12:49
whitz11whitz11
9013
asked Nov 22 '18 at 12:49
whitz11whitz11
9013
9013
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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 '18 at 13:15
NickNickNickNick
1698
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 '18 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 '18 at 13:26
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 '18 at 13:15
NickNickNickNick
1698
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 '18 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 '18 at 13:26
add a comment |
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 '18 at 13:15
NickNickNickNick
1698
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 '18 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 '18 at 13:26
add a comment |
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 '18 at 13:15
NickNickNickNick
1698
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 '18 at 13:15
NickNickNickNick
1698
answered Nov 22 '18 at 13:15
NickNickNickNick
1698
answered Nov 22 '18 at 13:15
NickNickNickNick
1698
answered Nov 22 '18 at 13:15
NickNickNickNick
1698
1698
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 '18 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 '18 at 13:26
add a comment |
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 '18 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 '18 at 13:26
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 '18 at 13:24
Spot on! frustrated with myself for not working that out, thank you
– whitz11
Nov 22 '18 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 '18 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 '18 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.
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
