The first time I ran Eirikur's code the 'Cast Right Left Trim' was the fastest, I didn't get a screen shot of that.
I've ran it about 6 times now, all...

Thanks Jeff and Eirikur.  Learned something new today, and I made a bad assumption that the substring would be the slowest solution.
I have sent off an email asking that...

I see your issue now, I've never done that.
Maybe check out trying to create a 'List' report.
https://docs.microsoft.com/en-us/sql/reporting-services/tutorial-creating-a-free-form-report-report-builder?view=sql-server-2017

From what I remember Informix isn't very good at telling you what part of the code it is having issues with,  it could be the CTE or the CROSS Apply. ...