Add last update to a task report

[PHenn]

Hello, I created a status task report and think it would be great to pull in the last update that was made.  I'm using text mode from the 2017 Reporting cookbook, but it isn't working correctly.  Furthermore, after I copy and paste it in text mode, the sequence of the code changes. 

Code from cookbook. 

displayname=Last Note
querysort=lastNote:entryDate
textmode=true
valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open
for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0,
CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))
valueformat=HTML
width=250
usewidths=true

Code once pasted into WF. 

CONCAT({lastNote}.{noteText},"=-- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))
displayname=Last Note
for=more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0,
querysort=lastNote:entryDate
usewidths=true
valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open
valueformat=HTML
width=250

I'd appreciate any help you could provide.  Thank you. 

[skyehansen · Accepted solution]

everything between “valueexpression” and “valueformat” should be one long line. Instead, it looks as though you have somehow introduced several linebreaks into your code—probably as part of the copy/paste process.