Hi,
I am having trouble with a Start Expression in a report template.
<<Start: SELECT(Field Data[Key],AND([Date]>=[_THISROW].[Date From], [Date]<=[_THISROW].[Date To],IN([Watershed],[_THISROW].[Watershed]), IN([Site Name],[_THISROW].[Site Name]), IN([Purpose of Visit],[_THISROW].[Purpose of Visit])))>>
I am receiving this error: should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the 'Key' column of the referenced table.
If I test the expression in a virtual column it seems to work and does display the filtered rows that I am expecting to see. Also, if I remove the last three clauses of the AND() and just use the date conditions it works well in the report template;
<<Start: SELECT(Field Data[Key],AND([Date]>=[_THISROW].[Date From], [Date]<=[_THISROW].[Date To]))>>
I feel like I am missing something obvious. Thanks in advance for your help.
LinkedIn
Twitter
