I want to do conditional formatting on a particular column called "HubArrival" which is DateTime format. I want it to have a pink background if the difference between HubArrival and BookedArrival is greater than 45 minutes, and I have set up conditional formatting to do this. Here is the code from the resulting designer file:
formattingRule2.Filters.Add(new Telerik.Reporting.Filter("AddMinutes(Fields.BookedArrival, 45)", Telerik.Reporting.FilterOperator.LessThan, "Fields.HubArrival"));
On running the report, an error occurs stating that DateTime cannot be compared with text - but both fields are of type DateTime.