I think is quite a common scenario, so I was wondering if is there a "simple" way to do the sorting and filtering (with NeedDataSource).
Displaying both in a template column is quite straightforward just Trim(Item.LastName & " " & item.FirstName)
Filtering in SQL Server should be something like "WHERE Trim(LastName+' '+FirstName) LIKE... (filter options)"
Sorting of course should be " ORDER BY LastName ASC,FirstName ASC " and " ORDER BY LastName Desc, FirstName Desc"
Any hint?
Displaying both in a template column is quite straightforward just Trim(Item.LastName & " " & item.FirstName)
Filtering in SQL Server should be something like "WHERE Trim(LastName+' '+FirstName) LIKE... (filter options)"
Sorting of course should be " ORDER BY LastName ASC,FirstName ASC " and " ORDER BY LastName Desc, FirstName Desc"
Any hint?