Method:Classic General Q&A

Re: Report Designer Conditional Formatting based on Text?

Maureen — Thu, 04 May 2017 16:37:56 GMT

Thanks Ben!! I most Definately would not have gotten there on my own!!

Much Appreciated! (I was looking for a happy dance emoji but didn't find one)

Re: Report Designer Conditional Formatting based on Text?

Method_Ben — Thu, 04 May 2017 15:51:52 GMT

Hi Maureen,

No Problem! Happy to help.

To get the formatting to also apply to strings not exactly matching the field - you can utilize the CharIndex('String1','String2') Function. CharIndex takes String1 (the value you are checking for - 'Ready' in this case) and compares it against String2 - returning the position where the function found a match. If no Match is found, the function will return -1 as the position value.

So, leveraging this function - your formatting would look something like this -

(CharIndex('Ready', [FieldName])) != -1

Basically - the Conditional Formatting will occur if there is any 'position' value returned by the CharIndex function (i.e. It found a match).

Thanks Maureen!

Regards,

Ben

Re: Report Designer Conditional Formatting based on Text?

Maureen — Thu, 04 May 2017 15:00:43 GMT

Hi Ben,

Thank you for your help! I can get that to work if I use the exact match of all words in the field. However if I want the condition based on the inclusion of just 1 word from a phrase in the field, how do I do that? I did use just the single quotes and I have tried changing "Like" to "In", but that does not work. I get no reaction if I don't use the entire phrase.

Re: Report Designer Conditional Formatting based on Text?

Method_Ben — Wed, 03 May 2017 21:35:46 GMT

Hi there Maureen,

The Conditional Formatting for Text is much the same as the conditional formatting you are used to using for Numerical values.

For your Scenario - The Formula applied to your control would look something like

[FieldName] Like 'Ready' - Making sure to use the Single quotes to Bookend the string you are comparing. Alternatively, you can use == instead of Like if you are sure that "Ready" will be the only data in this field.

Thanks Maureen!

-Ben

Report Designer Conditional Formatting based on Text?

Maureen — Tue, 02 May 2017 20:21:08 GMT

I am familiar with report designer and can make conditional formatting work when it is numbers that I am dealing with, however I can not figure out what formula to use when for instance I want the text to be Red if it includes the word "Ready". Can Anyone help me with this?