Conditional formatting how to do it. Please help me

[ankur10]

Hi Everyone,
Conditional formatting how to do it  . Please help me

Requirements-

I have 3 columns, based on the Status column. I have to put conditional formatting.

•   Status column when I filter for the report it gives me 4 other subfields ie. Interviewing, sendouts, open requirements, sourcing.
•   I have to give individual conditional formatting to every sub column of Status based on the no of days open.
•   Even when I filter any of sub column eg- I can filter interviewing but I'm not able to give it conditional formatting (as requirement is if it is open for 2 days give different color, if it is more than 2 days open give different color. Same goes with every sub column of status)

Thought of using –

Case when but it didn't work

Case when
[Query].[Status]='3:Sendouts' And
[Query].[Days open] Between 2 and 4
End

Screen shot attached.

[Lynn]

Hi Everyone,
Conditional formatting how to do it  . Please help me

Requirements-

I have 3 columns, based on the Status column. I have to put conditional formatting.

•   Status column when I filter for the report it gives me 4 other subfields ie. Interviewing, sendouts, open requirements, sourcing.
•   I have to give individual conditional formatting to every sub column of Status based on the no of days open.
•   Even when I filter any of sub column eg- I can filter interviewing but I'm not able to give it conditional formatting (as requirement is if it is open for 2 days give different color, if it is more than 2 days open give different color. Same goes with every sub column of status)

Thought of using –

Case when but it didn't work

Case when
[Query].[Status]='3:Sendouts' And
[Query].[Days open] Between 2 and 4
End

Screen shot attached.

Chapter 15 of the version 10.2.2 user guide contains information about using conditions.

I tend to use advanced conditional styles (click on your status field and click the ellipsis on the conditional style property. Select new, and then advanced conditional sytle) but a simple style may work for you.

[ankur10]

Hi Lynn, thank you for replying back. I have tried to do but it im not able to. Could you please guide me what steps to take. I'm not sure but if you're asking me to check conditional explorer. Please let me know thank you for your time and help.

Sent from my MotoE2 using Tapatalk

[Lynn]

Hi Lynn, thank you for replying back. I have tried to do but it im not able to. Could you please guide me what steps to take. I'm not sure but if you're asking me to check conditional explorer. Please let me know thank you for your time and help.

Sent from my MotoE2 using Tapatalk

Look at page 381 in the report studio user guide. This is the beginning of Chapter 15 that talks about conditional styles. The user guide does a far better job of listing out the steps to take.

I am not referring to the condition explorer although that is an alternate approach to take, just not one that I prefer.

[ankur10]

Hi thank you for the reply.

I have tried these steps.

However this doesn't helps the scenario as, under status I have 4 different sub fields and i would like to have formatting on each of them individually and that also different formatting.

I'm sorry for being trouble to you and thank you for your help. Please guide how to achieve this.
---------------------------------------------------------------------------------------------
Create a New Conditional Style
You can apply conditional styles based on any data item in your report.
Procedure

1. Click the object for which you want to define a conditional style and click the
conditional styles button .

Tip: You can also right-click the object and click Style, Conditional Styles or
click the object, and then, in the Properties pane, set the Conditional Styles
property.

2. Click the add button and click New Conditional Style.

3. Select the data item to determine the condition and click OK.

The type of conditional style that you can use depends on the type of data item
you select.

4. In the Name box, type a name for the conditional style.

5. To define a numeric value, date/time, date, time, or interval condition:

v Click the new button and select a value to define a threshold.
------------------------------------------------------------------------------------------------------------------

[ankur10]

Example if- Sendouts value is 2 it should different colour, if value 3 different same for all the 4 different status.

Thank you for your time and help.

[Lynn]

Continue reading to find the advanced conditional style section. The steps you describe are for a simple conditional style.

With advanced styles you can create an expression to control highlighting for different circumstances.

For example, you might have the conditions below to highlight a certain way for different combinations of two values:

Code Select Expand


[Value] = 2 and [Sub Type] = 'Interviewing'


Code Select Expand


[Value] = 3 and [Sub Type] = 'Interviewing'


and so on....

[ankur10]

Thank you so much for your help and time. I will try the steps you have recommended me.

Will tell you after trying this.