ashwken
07-09-2008, 09:26 AM
It would appear that Attribute Names are case-sensitive when used in Title Expressions.
This expression generates a SYNTAX ERROR:
trim(coalesce(
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_SubType] || ' - ' || [Ev_MoreTitle],
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_SubType],
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_MoreTitle],
[Ev_Date] || ' - ' || [Ev_Type],
[Ev_Date],
'(Lead Event)'
))
This Attribute is actually named [EV_MoreTitle], renaming this Attribute to match the case shown in the expression corrected the error.
This expression generates a SYNTAX ERROR:
trim(coalesce(
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_SubType] || ' - ' || [Ev_MoreTitle],
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_SubType],
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_MoreTitle],
[Ev_Date] || ' - ' || [Ev_Type],
[Ev_Date],
'(Lead Event)'
))
This Attribute is actually named [EV_MoreTitle], renaming this Attribute to match the case shown in the expression corrected the error.