I have two separate columns in a database table - first name and last name - that I am representing in a Radzen Datagrid with the option of exporting to XLSX. I would like two combine the data in these two fields so that it appears in a single column - full name - in the XLSX export.
This is my code as it stands:
public async Task ExportExpenseRecords(string type)
{
await _exportService.Export("expense-records-paid", type, new Query()
{
OrderBy = expenseRecordGrid.Query.OrderBy,
Filter = expenseRecordGrid.Query.Filter,
Select = "CreateDate, Expense.User.FirstName, Expense.User.LastName, ExpenseType.Name AS ExpenseType, ExpenseReason, Amount"
});
}
I have tried various things to get the first name and last names to export to a single column but so far haven't had any luck. Is this possible?