CONCATing a field for a report
Posted: Fri Jan 19, 2018 11:56 pm
I need, in a report I'm building, to combine two columns (cust_LastName and cust_FirstName), into one report field (to be used as a group header and report ORDER BY-- I don't want the report simply sorted by "cust_LastName", I want it sorted and grouped by "cust_LastName, cust_FirstName").
In other places (for example, browse forms and select boxes on forms), I've been able to specify the SQL statement CONCAT(cust_LastName,", ",cust_FirstName) and it's worked well. For example: However, I'm not finding a way to do this for a report field. I've tried making the report's underlying SQL include CONCAT AS Name, but that gets blown out when the SQL Builder closes. I've tried adding a field in the Fast Reports builder then changing the Field Name column to the desired SQL statement, but that causes PHP errors when I try to run the report and causes the report to not be editable (the window opened when the Report Designer button is clicked, is blank.)
Is there any way to do what I'm wanting to do?
Thank you!
Mike
In other places (for example, browse forms and select boxes on forms), I've been able to specify the SQL statement CONCAT(cust_LastName,", ",cust_FirstName) and it's worked well. For example: However, I'm not finding a way to do this for a report field. I've tried making the report's underlying SQL include CONCAT AS Name, but that gets blown out when the SQL Builder closes. I've tried adding a field in the Fast Reports builder then changing the Field Name column to the desired SQL statement, but that causes PHP errors when I try to run the report and causes the report to not be editable (the window opened when the Report Designer button is clicked, is blank.)
Is there any way to do what I'm wanting to do?
Thank you!
Mike