This is a migrated thread and some comments may be shown as answers.

Conditional formatting - double condition

1 Answer 244 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Felice
Top achievements
Rank 1
Felice asked on 08 Jun 2014, 06:28 PM
Hi,
I have added a conditional formatting in one of my report to make red a date if it is older than 30 days:

=Field.StatusDate <= = Now().AddDays(CDBl(-30)))       then I apply the style : background = red

The above is working fine and I get the desired result.

My problem now is to exclude from the above conditional formatting the values having "Field.StatusDate older than 30 days" where the "Field.Status" value is ="B"

Can some one help please?

Thank you,
Felice

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 11 Jun 2014, 03:10 PM
Hello Felice,

In the rule filter's expression you can use any of the available operators to build a compound logical
expression.

For example:
Expression: = Fields.GroupName like '%u%' and Fields.DepartmentID>9
Operator: = (equal sign)
Value: = True

I hope this helps you.

Regards,
Stef
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
General Discussions
Asked by
Felice
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or