Conditional Formatting Rules

[cheekl]

Hi,
I created a conditional formatting rules for subreport
where
expression = Fields.Item1
Operator = In
Value = 1,2,3
style.visisble = false

But the subreport still visible. If i create multiple rules using operator "=" then it works.
How can I use operator "In"?

[Peter]

Hi Cheekl,

The IN operator requires an object array but the expression engine doesn't supports syntax for specifying object array. However you can use an user function to convert a comma separated string value to an object[] as shown in the following code snippet and sample value expression:

public static object[] ConvertStringArray(string value)
{
    return value.Split(',');
}

= ConvertStringArray("1,2,3") 

All the best,
Peter
the Telerik team

[cheekl]

Hi Peter,
Thanks for your help. It works.