I'm using Report Builder 3.0 for a report that queries some Teradata databases. A user has notified us that they can't export the results to more recent versions of Excel. They get a message about illegal xml characters. I've searched through the results and it appears that the illegal characters are apostrophes (') and ampersans (&). I done some research and came across the OREPLACE function to replace these characters in 4 columns. Below are the 4 select statements where I used this feature.
When I try and run the SQL now, I get a "SELECT Failed  Response Row size or Constant row size overflow" error message.
I'm assuming that my syntac is wrong or I've fouled something else up. Is there a better way to replace these 2 special characters?
thanks for the help.....
CASE WHEN j.acct_name IS NOT NULL THEN oreplace(j.acct_name, '''','') ELSE dv.dvr_srnm || ', ' || dv.dvr_frst_name || ' (DRIVER)' end AS "ACCOUNT/DRIVER NAME",
oreplace(oreplace(journal_desc, '&', 'and'),'''',' ') AS "Jrnl Description",
oreplace(e.FIRST_NAME,'''', '') ||' '|| oreplace(e.LAST_NAME,'''','') AS AdjBy,
oreplace(oreplace(reason_desc, '&', 'and'),'''',' ') AS "reason desc",
Solved! Go to Solution.