I have winforms application using telerik reporting. I have it connected to my database. I am always getting false for the following check in my group footer:
Problem
= IIf(Last(Fields.AllActivityLog_Purpose) In ('Remove [-]', 'Remove [-All]'), "true", "false")
Always returns "false". This is absurd?
Sanity Check 1:
=Last(Fields.AllActivityLog_Purpose)
it comes up as 'Remove [-]'.
Sanity Check 2:
=Len(Last(Fields.AllActivityLog_Purpose))
=Len('Remove [-]')
I get 12 for the first result and 11 for the second result.
Sanity Check 3:
=StringCompare(Last(Fields.AllActivityLog_Purpose), 'Remove [-]') returns 1
Help
How can I get the Last(Fields.ActivityLog_Purpose) to pass it's check?
Problem
= IIf(Last(Fields.AllActivityLog_Purpose) In ('Remove [-]', 'Remove [-All]'), "true", "false")
Always returns "false". This is absurd?
Sanity Check 1:
=Last(Fields.AllActivityLog_Purpose)
it comes up as 'Remove [-]'.
Sanity Check 2:
=Len(Last(Fields.AllActivityLog_Purpose))
=Len('Remove [-]')
I get 12 for the first result and 11 for the second result.
Sanity Check 3:
=StringCompare(Last(Fields.AllActivityLog_Purpose), 'Remove [-]') returns 1
Help
How can I get the Last(Fields.ActivityLog_Purpose) to pass it's check?